Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

replication - which solution best ?

0 views
Skip to first unread message

Leszek Kosinski

unread,
Jan 15, 2003, 12:19:43 PM1/15/03
to
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

Mike Dunn

unread,
Feb 12, 2003, 11:40:36 AM2/12/03
to
Leszek,

Not sure if you've looked at it, but PeerDirect has a trigger based
replication engine that works well with different versions of database
servers.

Regards,

-Mike

"Leszek Kosinski" <l_kos...@yahoo.com> wrote in message
news:9c0814a3.03011...@posting.google.com...

0 new messages