Sybase->Oracle replication

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 Tue Nov 09 1999 - 14:58:13 CST