On Wed, Feb 15, 2017 at 6:43 PM, 'Leyne, Sean' Sean@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

Walter,

> 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"?

The Firebird ISQL tool does not support such a feature.

You could create 2 output files and then use command line utility to combine results into single file.

There are some third-party tools which could allow you to script this process (I know that IBExpert supports it)


Sean