Subject Re: [firebird-support] Is there an easy way for input rows from a script file?
Author Walter R. Ojeda Valiente
Thank you, Sean



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


> If I connect to a database "Database1" using ISQL, I can write something like:
> SELECT * FROM MyTable;
> 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)