As of version 1.15 of the DBCopy Plugin, a new command-line interface is available for
copying tables. This can be useful for scripts in cases where copying is to be done
in an automated way without a user present. There is a super-jar available for
download here: repo1.maven.org/maven2/net/sf/squirrel-sql/cli/dbcopy/<version>
It can be run with this command:
java -jar dbcopy-cli-<version>.jar
and has the following usage:
usage: DBCopyCLI --dest-alias --dest-catalog | --dest-schema
--source-alias --source-catalog |
--source-schema --table-list | --table-pattern
--dest-alias The name of the destination alias to copy
tables to
--dest-catalog The destination catalog to copy tables into
--dest-schema The destination schema to copy tables into
--source-alias The name of the source alias to copy tables
from
--source-catalog The source catalog to copy tables from
--source-schema The source schema to copy tables from
--table-list A comma-delimited list of tables to copy
--table-pattern A regexp pattern to match source table names