Re: Sybase->Oracle replication

If Oracle is the "center of the world" in your organization, 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 heterogeneous database replication as would an Oracle to Oracle or MS-Sql to MS-Sql environment. There are probably other paths for "replicating" data on a "foreign" database, but this is a cheap one.

(btw: we also use this for our "interfaces" between foreign systems.)

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

<dpurrington_at_my-deja.com> wrote in message news:80a1t3$gb5$1_at_nnrp1.deja.com...
> I realize this is mostly a Sybase question, but in case Oracle has a
> solution I've overlooked . . .
>
> I need to replicate from Sybase to Oracle, and this is a large volume
> database (~10-12M nightly, 10% monthly growth). A real-time (or near
> real-time) replication is not necessary, but okay. A full, nightly
> data refresh won't work.
>
> What won't work:
> -- nightly full data refresh via some kind of BCP method. Since the
> volume is large, this is not an option.
> -- dump and load transaction logs. This would only work replicating to
> a Sybase database. *Correct me if I'm wrong?*
>
> What would work:
> -- Replication Server with DirectConnect for Oracle. I'm looking for
> another option here b/c it seems difficult to work with, and little
> documentation.
>
> -- Component Integration Services with some kind of automated,
> incremental data propagation? What I need is something similar to
> Oracle's snapshots, but I can't seem to find anything similar in
> Sybase. *Is there something like this?* Perhaps I'm not familiar
> enough with the nomenclature . . .
>
> In addition, because of a quirky third-party design, the source
> database has multiple identical dbs. *Can I merge the data into one
> target table from multiple replicated tables?* I was thinking that
> with replication server, I would create a rep def for each db-schema
> combination, but identical tables would have the same target table.
> And with the CIS solution, it would be a requirement of whatever
> snapshot-type of functionality I could devise.
>
> Any help anyone can provide would be greatly appreciated!
>
> Thanks,
> Dave Purrington
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 10 1999 - 15:47:57 CST