Subject | RE: [firebird-support] How to simply copy table data from one db to another one |
---|---|
Author | Adrian Wreyford |
Post date | 2005-07-05T11:46:07Z |
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
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
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 toQLI.
> 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.
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