Re: Replication

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Tue, 16 Jan 2001 22:02:24 +0100
Message-Id: <10743.126837@fatcity.com>

Any reason for not using flat files and SQL*Loader ? Still seems to me the safest (and possibly fastest) for moving big volumes between heterogeneous environments.

Regards,

Stephane Faroult
Oriole Corporation

Sherrie.Kubis_at_swfwmd.state.fl.us wrote:

> 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 - 15:02:24 CST