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:

> INSERT INTO A_TABLE
> SELECT * FROM B_TABLE
> 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.

HTH,
Jason


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