> my mistake - not across databases. you'll need QLI or manually via

datapump.

> Or you'll need to write you're own code to pump the data..
> select field1, field2,.. from database1_table
> insert into database2_table (field1, field2,..) values (:param1,
> :param2,... ) etc
> Alan
>

<shameless advert>

Firebird Workbench and InterBase Workbench both have an easy-to-use
DataPump tool included ( www.upscene.com ) that can transfer data from
any ODBC/ADO/IB/Fb datasource to ODBC/ADO/IB and Fb. It also has
a command-line version to run from the Windows scheduler.

</shameless advert>

Also IBDataPump ( www.clevercomponents.com ) can do this for you.



With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."