Subject RE: [firebird-support] How to simply copy table data from one db to another one
Author Adrian Wreyford
Excuse my ignorance, but what is QLI?
Adrian

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: 04 July 2005 12:43 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to simply copy table data from one db to
another one

>I need in my application to copy a whole table from one FB database to
> another FB database. Is there a solution like "select * into dest from
> src"?, or the only solution is to copy row by row, field by field?
> I need to copy the content, not the structure that is already defined.
> Thanks for your help.

QLI.

Example:

ready server1:c:\db1.fdb as db1
ready server2:c:\db2.fdb as db2
db2.tablename = db1.tablename

Ivan
http://www.volny.cz/iprenosil/interbase/



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links