|Subject||Re: [firebird-support] Is there an easy way for input rows from a script file?|
|Author||Walter R. Ojeda Valiente|
On Wed, Feb 15, 2017 at 6:43 PM, 'Leyne, Sean' Sean@... [firebird-support] <firstname.lastname@example.org> wrote:
> If I connect to a database "Database1" using ISQL, I can write something like:
> OUTPUT MyFile.DAT;
> 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)