In Oracle and SQL Servers I'm Updating the data manually. But I want make it Automated Process(Updating required columns automatically) in SQL Server by using trigger during manual update in Oracle's table with respect to column .
Is this possible?
Im using Oracle 11g in linux and SQL Server 2005 in windows.
Both Servers are in different locations , but are in same network and not connected with ODBC , dblink .
I need your Valuable assitance and Helpful guide for succesfully completing my task.
Yes, you can update SQL*Server tables from Oracle using triggers if you install and use the Database Gateway for SQL*Server (DG4MSQL). You need to use DG4MSQL because it supports distributed transactions so that the Oracle and SQL*Server commits can be synchronised and both will be rolled back if there is an error.
You could use the Database Gateway for ODBC (DG4ODBC) but you would have to write your own error routines to handle problems if the commits fail in either Oracle or SQL*Server.
There is more information about the gateways in this note available in My Oracle Support -