On Thu, Feb 16, 2017 at 3:44 AM, hvlad@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

---In firebird-support@yahoogroups. com, <sistemas2000profesional@...> wrote :

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