Home » Server Options » Streams & AQ » Oracls stream and sql server replication (oracle 11.1.0.7 sqlserver 2008)
icon4.gif  Oracls stream and sql server replication [message #426489] Thu, 15 October 2009 19:38
pbilodeau83
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
source
Destination

Sqlserver database name
report

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

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


Current Time: Fri Mar 29 05:47:50 CDT 2024