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?

Roger responded:
> WHERE .....

The tables are in separate databases, so using a single SQL statement is not
sufficient. TIB_Datapump is the best way to go.

Additionally, I recommend that you do it local to the inserts as they are
sent one at a time, vs. the selection of records which allows for the
network to bunch them up with multiple records in a single packet.

In short, if you can, pull, don't push.


[Non-text portions of this message have been removed]