Oracle-L: Re: Replication from DB2 to Oracle

From: Govindan K <gkatteri_at_omanmail.com>
Date: Fri, 26 Sep 2003 10:09:40 -0800
Message-ID: <F001.005D1331.20030926100940@fatcity.com>

Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface
>From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the
Java/C program
which will in turn connect to Oracle and carry out DMLs.

HTH
GovindanK

<-----Original Message----->

From: Govindan K
Sent: 9/25/2003 1:15:22 PM
To: ORACLE-L_at_fatcity.com;ORACLE-L_at_fatcity.com

Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication
across Databases of diff.vendors is still not avbl. though it seems you can do DMLs
from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. Don't know about the reverse.

Or you may considering any of the following: 1. Dump the DB2 data onto flat file and load using sqlldr / External Tables.
2. Generate SQL insert statements using the equivalent of triggers (capturing
the DMLs in the same sequence) and run it in Oracle.

In either of the above cases , how are you going to handle DDLs if any that are
being done in DB2. The same need to be propogated to Oracle too and the subsequent data inserted correctly.

HTH
GovindanK

<-----Original Message----->

From: Rishi.Jain_at_VerizonWireless.com Sent: 9/25/2003 12:05:43 PM
To: ORACLE-L_at_fatcity.com

Hi,

Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in
the market ? I would really appreciate if you could suggest something.

I am looking to replicate around couple of hundred thousand rows a day. The
replication can be every couple of hours. Our main concern is performance on
the transactional system ( source system running db2) should not have significant performance impact.

Thanks.

Thanks

Rishi Jain

Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS NOW!
<http://ads.arabia.com/?SHT=text_email_english>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Govindan K
  INET: gkatteri_at_omanmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Sep 26 2003 - 13:09:40 CDT