Re: Sybase->Oracle replication

From: <dpurrington_at_my-deja.com>
Date: Thu, 11 Nov 1999 14:03:50 GMT
Message-ID: <80eic4$pcu$1@nnrp1.deja.com>

Thanks for the reply. You wrote:

> then look into Oracle's transparent gateway, which allows
> you to establish an ODBC connection to the Sybase database
> and perform table reads and writes. It does not permit

We're not on a Microsoft OS so ODBC isn't available. I don't think ODBC can handle that kind of volume anyway. This gateway option is still available using Oracle's Open Gateway, but I need a transaction- based solution. It's just too many tables to try to do it this way.

You *could* use this method along with snapshots, but snapshots across disparate systems prohibit the fast-refresh method.

> If Sybase is the "center of the world", switch to Oracle.

Ha ha.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 08:03:50 CST