Subject RE: [IBO] Copy entire records without specifying the fields? IB_Datapump?
Author Jason Wharton
John wrote:
> I want to copy records from tables in database A to tables in
> database
> B. Both databases have the same structure. Records in source_table do
> not exist in destination_table.
> Is there a way to read a record from A.table and subsequently
> insert it
> in the corresponding B.table regardless of the
> recordstructure (which is
> the same in both tables) ?
> I have about 30 tables to process this way and somehow I think I
> shouldn't write 30 different SELECT and corresponding INSERT
> statements
> specifying all fields etc.
> Can/should I use IB_Datapump?

This is exactly when you should use the datapump.

If the structure is the same it will bind the statements to the same buffer
space and save a lot of effort. It also hooks into lower level layers and
makes the data transfer as quickly as possible.

Jason Wharton