Re: replication - which solution best ?

Leszek Kosinski wrote:

> I am looking for the best event triggered replication solution for a
> many to one configuration, as close to real time as possible, where
> databases would be replicating over WAN. Replication should include
> database objects as well (once a new database object created, it
> should be reflected on the replica).
>
> I have looked at Oracle Streams, materialized views and a Sybase
> Replication server.
>
> How do these solutions work, from the following perspectives:
>
> - multiple Oracle databases versions
> - big or increasing data volumes
> - % of integration work type - product configuration vs. customized
> implementations ?
> - resynchronization upon restarting db servers
> - possibility of replicating data from SQL Server databases
>
> Thanks,
> Leszek

You have a lot of things confused in here. What do Sybase and SQL Server have to do wtih Oracle replication?

Please clarify your request and provide a better sense of what you want to do, the size of the database, the number of transactions per time period, why anyone is running DDL on a production box? and ...

most imporantly ... please stop cross posting to every usenet group. One is enough.

I have intentionally removed all irrevant groups from my response.

Daniel Morgan Received on Wed Jan 15 2003 - 16:37:28 CST