Subject Re: [firebird-support] copying data between FB DBs on the same machine
Author Aage Johansen
On Tue, 12 Aug 2003 00:43:01 +0000 (UTC), opher_shachar wrote:

> Hello all,
> I'm a newbie to FB - but not to RDBMS (I've worked for years now with
> Pervasive.SQL & MS SQL 7).
> I have to different DBs on one server machine (ie. 'DB1.fdb' & 'DB2.fdb')
> , and I need to copy data from a table in one DB to the other DB.
> Currently I do this from inside my program: I copy data between two
> recordsets.
> This is highly inefficient: Data traveles twice over the network (Server -
> > Client -> Server)
> Question: Can I do this by means of an sql INSERT/SELECT?
> In MSSQL7 I would use: insert into table1 select * from DB2..table2
> Quick and painless :-)

Can you run your program directly on the server? If so, the traffic over
the network cables should be eliminated.
It may even be possible to use the QLI program.

Aage J.