Home » Server Options » Streams & AQ » Oracls stream and sql server replication (oracle sqlserver 2008)
icon4.gif  Oracls stream and sql server replication [message #426489] Thu, 15 October 2009 19:38
Messages: 1
Registered: October 2009
Junior Member
Hi i got 3 database, 2 oracle and one sql server, i want do this

oracle database name

Sqlserver database name

i configure an oracle stream between source and destination in one direction. it is work fine, when i modifiy data in source table it is replicate in destination table.

After that i configure replication in sql server to point with linked server on oracle destination tables for replication.

now if i modify data in source, destination change but sql server not. It is like sqkserver does not detect change..

if i created a table in oracle destination database and add it to sql server replication, i can modify or add data in oracle destination table sql server can add or modify data in sqlserver database, it is like after commit sqlserver detect chage and apply it.

Does this tell something to someone?

For now i search to do the same thing by do an oracle stream between oracle destiontion and sqlserver...

Thanks for your help

Previous Topic: Is Stream Replication is good for dynamic databases.
Next Topic: 10g R2 Streams and RAC
Goto Forum:

Current Time: Tue Aug 03 15:10:07 CDT 2021