Tools for DB2=>Oracle replication

From: <michael_at_geo-da.co.il>
Date: 23 Feb 2006 12:54:46 -0800
Message-ID: <1140728086.276313.95150_at_p10g2000cwp.googlegroups.com>

Hi!

One of my clients wants to replicate about 20mlns of records daily from Db2 to Oracle.
Currently they export data to flat file and then load it to Oracle with SQL Loader.
I suggested to use Oracle Gateway, but I'm curious about the speed. I used Oracle Gateway with Image SQL on HP 3000 and it was quite slow. What is the best tool to do the task?
Flat file?
Oracle Gateway?
Various data transfer software like DbPut or SQLWriter? TIA
Michael Received on Thu Feb 23 2006 - 21:54:46 CET

This message: [ Message body ]
Next message: der mak: "Re: Upper/Lower Case Selektion Performance"
Previous message: Gerard H. Pille: "Re: Upper/Lower Case Selektion Performance"
Next in thread: sybrandb_at_yahoo.com: "Re: Tools for DB2=>Oracle replication"
Reply: sybrandb_at_yahoo.com: "Re: Tools for DB2=>Oracle replication"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message