| Subject | Re: Is there an easy way for input rows from a script file? |
|---|---|
| Author | |
| Post date | 2017-02-16T07:44:19Z |
---In firebird-support@yahoogroups.com, <sistemas2000profesional@...> wrote :
Hello everybody
If you need to export some data from one Firebird database to another Firebird database, use EXECUTE STATEMENT ... ON EXTERNAL and forget about files.
Regards,
Vlad
Hello everybody
If I connect to a database "Database1" using ISQL, I can write something like:
OUTPUT MyFile.DAT;
SELECT * FROM MyTable;
OUTPUT;
And all the rows of "MyTable" will go to the text file "MyFile.DAT". That's ok and works fine.
But now, I want to connect to "Database2", which also have a table called "MyTable" and with the same structure.
After that, I want to insert into "MyTable" (of "Database2") the rows contained in "MyFile.DAT"
How can I do such thing without a lot of effort writing an INSERT command in each line of "MyFile.DAT"?
If you need to export some data from one Firebird database to another Firebird database, use EXECUTE STATEMENT ... ON EXTERNAL and forget about files.
Regards,
Vlad