|
From: Robert M. <rob...@gm...> - 2011-04-22 11:45:31
|
Hi Bruce, It wouldn't be that hard to write a wrapper for the DBCopy plugin that accepts source/destination aliases via command-line arguments or a properties file. You could add a feature request for this here: https://sourceforge.net/tracker/?func=add&group_id=28383&atid=393417 <https://sourceforge.net/tracker/?func=add&group_id=28383&atid=393417>Rob On Thu, Apr 21, 2011 at 2:29 PM, Bruce Adams <tor...@ya...>wrote: > Hi, > SquirrelSQL has a lot of nice features that as far as I can tell are > only > available via the GUI. For example the DBCopy plug-in allows > > (with varying success) the cutting and pasting of tables between databases > even > when they are from different vendors. I would like to be > able to automate some of these things for example from the command line. > > squirrel-sql dbcopy <database1> <database2> <table1> <table2> > > I could then embed this in shell scripts or elsewhere. > Another option would be a scripting interface. For instance a lot of > programs on > the old Amiga provided rexx ports allowing one application to control > another. > The sql scripting plugin for squirrel doesn't seem to be aimed at this > case. > > So I have the following questions: > > 1. Is there any way to do the kind of automation I'm talking about that > I've > missed. > E.g.using te scripting plugin somehow. > > 2. Are there any plans to provide some kind of automation support? > > 3. Are there any plans to extend the DBCopy plugin to run as a stand-alone > program? > > 4. How hard would it be to: > a. add a scripting interface to squirrel > b. write a wrapper to DBCopy > > I am a developer but not primarily a java one. That said, I might be able > to > find time to work on some of these angles myself. > > 5. Who else is interested in this? > > 6. What other options are there that I've missed? > Liquibase doesn't currently match dbcopy for cross database copying > DBUnit I've yet to explore but is next on my list. > Anything else? > > Regards, > > Bruce. > > > ------------------------------------------------------------------------------ > Fulfilling the Lean Software Promise > Lean software platforms are now widely adopted and the benefits have been > demonstrated beyond question. Learn why your peers are replacing JEE > containers with lightweight application servers - and what you can gain > from the move. http://p.sf.net/sfu/vmware-sfemails > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
