Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication
<-----Original Message----->
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: [EMAIL PROTECTED] Sent: 9/25/2003 12:05:43 PM To: [EMAIL PROTECTED] Subject: Re: Replication from DB2 to Oracle 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!