Subject | Re: [firebird-support] Exporting insert statements - qli? |
---|---|
Author | Ann W. Harrison |
Post date | 2008-01-30T22:45:18Z |
Svein Erling Tysvaer wrote:
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
>for what it's worth - nothing in this case - copying the declaration
> 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).
>
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