Oracle11g installed on one machine to another machine on installed sqlserver2008, these two database with A table (call the oracle for A, is essentially to B), A and B is different, but some of the same field,

Want to do now is, when A field value on changes, through what kind of mechanism, immediately automatically change the corresponding fields in the data synchronization to B, at the same time is not used in other cooperate operation! ?

CodePudding user response:

First can be used as DG DBSync this kind of tool the second advice is to do a software or software to do something you can add my Q65620202 detailed explain to you how to operate

CodePudding user response:

Establish dblink between oracle and used, and then establish the trigger in the oracle table, according to the rules of writing used data

CodePudding user response:

OGG,,,,

CodePudding user response:

Different synchronization + some field synchronous + oracle to essentially same heterogeneous
I can think of:
1. The program
2. The CDC + program
3. Oracle trigger + transparent gateway to essentially DBLINK
4. Other ETL tools + program