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----->
<-----Original Message----->
From: Govindan K Sent: 9/25/2003 1:15:22 PM To: [EMAIL PROTECTED];[EMAIL PROTECTED] Subject: Re: Replication from DB2 to Oracle 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----->
_______________________________________________________________ Get Your 10MB account for FREE at http://mail.arabia.com ! |
_______________________________________________________________
Get Your 10MB account for FREE at http://mail.arabia.com !