replication - which solution best ?

From: Leszek Kosinski <l_kosinski_at_yahoo.com>
Date: 15 Jan 2003 09:19:43 -0800
Message-ID: <9c0814a3.0301150919.2f1c2071@posting.google.com>

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 Received on Wed Jan 15 2003 - 11:19:43 CST