Subject | Re: [ib-support] Copy from database 1 to database2 |
---|---|
Author | lester@lsces.co.uk |
Post date | 2001-12-17T15:04:03Z |
> I have 2 databases (db1 and db2).Not in SQL.
>
> I need to use a sql statement to copy data from tableX from db1 to tableY
> from db2
>
> How do I do that ???
> Do I have to include the database name (eg db1 or db2) in the query ???
In IBObjects you use a datapump, and connect the source and
destination to the different databases, but you can't do it
directly.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services