Re: replication - which solution best ?

From: Mike Dunn <nospam.mdunn_at_sscincorporated.com>
Date: Wed, 12 Feb 2003 11:40:36 -0500
Message-ID: <NFu2a.38114$AR5.15866@fe02.atl2.webusenet.com>

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_kosinski_at_yahoo.com> wrote in message news:9c0814a3.0301150919.2f1c2071_at_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 Feb 12 2003 - 10:40:36 CST