Replication

From: <Sherrie.Kubis_at_swfwmd.state.fl.us>
Date: Tue, 16 Jan 2001 15:36:32 -0500
Message-Id: <10743.126834@fatcity.com>

Environment:

Oracle 8.1.5.0.0. Compaq Tru64 UNIX
Oracle Transparent Gateway to DB2
DB2 database on an IBM mainframe

I presently copy data nightly from our IBM DB2 database into Oracle using 'complete' refresh snapshots. 'Fast' refreshes cannot be done because of the different database architectures. While this suffices for small dataset replication, we will soon have a requirement to transfer quite a bit of data (size undetermined at this time, other than 'lots'). Is there anyone out there doing this kind of thing between disparate databases? A software tool that may work? Any insights would be appreciated.

Sherrie Kubis
Southwest Florida Water Management District 2379 Broad Street
Brooksville, FL 34604
352.796.7211 Ext 4033
Fax: 352-754-6776
sherrie.kubis_at_swfwmd.state.fl.us Received on Tue Jan 16 2001 - 14:36:32 CST