How to copy one table from one database to an identical table from the other database?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question: How can I copy one table from one database to an identical table to the other database as fast as possible? The databases are identical, the first (source) is filled, the second (destination) is empty.
Ansver: Please have a look at the examples in our Download section. There you may find an example of the BatchToQuery method for automatic data copying from one table to another from different databases.
What a good job you did! Keep coding great pieces of fast and efficient software:) We started using FIBPlus back in 2001. Since then, every project we offer uses FIBPlus to connect to FirebirdSQL. You library has always been stable, flexible and rocket fast ! Our major project, an helpdesk/data mining application, concurrently used daily by more that a hundred technicians and analysts, uses FIBPlus. Now that FirebirdSQL 2.0 is available, we have been able to upgrade our application quickly and painlessly - that's another reason you can be proud of your work ! >>Benoit Le Bourhis, Adhoc Innovations
