Hello Ann Thank you very much for your answer.
The databases are in location, the tables too, but without records yet, so I need to populate them. It is not possible a full backup/restore from a location to another because many tables has data and each location has its own data. There are some tables with common data and those I need to have in all the places. Greetings. Walter. On Thu, Aug 29, 2013 at 2:35 PM, Ann Harrison <[email protected]>wrote: > ** > > > 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] > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
