how to synchronize Oracle data with SQL Server I have an Oracle 11g database in one machine with unique a IP, and a SQL Server 2008 database in another machine.

A table (A) in Oracle has some fields (not all) which are the same as table (B) in SQL Server.

Now I want to synchronize the fields' values in A with the fields' values in B. That is (maybe it is wordy!), when the value changes in A, so it is automatically updated in B without any manual operation in SQL Server!

How to get this done?
Set up a database link between Oracle and SQL server, then set up a trigger in the Oracle database to update the SQL Server table whenever the oracle table changes.