 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
