On Thu, Aug 29, 2013 at 1:16 PM, W O <[email protected]>wrote:
> > > In a Firebird's datatabase I have a large table with thousands of records, > is there a simple way for send these records to a text file? > > My idea is to have a script with the "INSERT INTO" commands. > > Something like it: > > INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(1, 'Alicia', 444555); > INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(2, 'Beatriz', 654321); > > So, when I initialize the database in another location I can put all those > records into it using the INPUT command of ISQL. > > > That's the least efficient way to insert data - using a prepared statement that you activate and pass data to is much faster. Why not just backup the source and restore it to the new location? If you only want part of the data, you could write your data to an external file, then copy the external file to the empty database in the new location and move the data from the external to the internal table. Or use a tool that copies tables between databases. Good luck, Ann [Non-text portions of this message have been removed]
