Subject Re: [firebird-support] Exporting insert statements - qli?
Author Ann W. Harrison
Svein Erling Tysvaer wrote:
>
> And if you have two databases available simultaneously and you want to
> transfer from one table in one database to another table with identical
> structure in the other database, then qli can do this for you with just
> a few statements (I've done that once or twice, but a long time ago, and
> don't even remember where I saw the example I copied).
>

for what it's worth - nothing in this case - copying the declaration
and contents of the table "sample" from one database to another.

qli> ready database1.gdb as db1
qli> ready database2.gdb as db2
qli> define relation db2.sample based on db1.sample
qli> db2.sample = db1.sample
qli> commit

Cheers,


Ann