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:



On Thu, Apr 21, 2011 at 2:29 PM, Bruce Adams <tortoise_74@yahoo.co.uk> wrote:
   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
 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

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?



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