Use the datapump. with two TIB_Cursor comps and a SELECT * FROM table in
each one.

If you are merging then that means a different story. You may want to make a
stored procedure on the destination side that matches the table and then
pump into it.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Charles Urbina" <curbina@...>
To: <iBObjects@yahoogroups.com>
Sent: Friday, September 13, 2002 8:14 AM
Subject: [IBO] Insert Records from one database to another


> I have 2 identical databases in one database I have some tables with some
> records I need to insert on the second database in the same table from the
> 1st database.
>
> How can I transfer those records from databse 1 to database 2. The table
> structure are identical
>
> Tia
> Charles Urbina