|Subject||Re: [firebird-support] Re: Is there an easy way for input rows from a script file?|
|Author||Walter R. Ojeda Valiente|
Thank you Vlad, but is not for me, is for an article of my blog, I am showing the alternatives for exporting data.
On Thu, Feb 16, 2017 at 3:44 AM, hvlad@... [firebird-support] <firstname.lastname@example.org> wrote:
---In firebird-support@yahoogroups. com, <sistemas2000profesional@...> wrote :
Hello everybodyIf 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.