Re: Slow dbcopy?
Posted in 1999
Thomas Parsli — — source: Informix-list mailing list archive (1991-1998)
Jing Liu <jingliu@ics.uci.edu> writes:
> Thomas Parsli wrote:
[SNIP]
> > We're trying the unload->rcopy->load path, this seems faster on the
> > relativly small tests I've done. I suppose gzip could help with our 10Mb WAN...
>
> Is there any way to do unload and load automatically to copy multipile tables? I think it
> is not suported in routines.
I use perl-scripts with
$tables = 'echo "select tabname from systables where tabid >= 100 and
tabtype = 'T' order by 1" | dbaccess <dbname>';
to list all tables.
dbexport/import is fine, but it only works on the whole database.
Thomas