This discussion is archived
2 Replies Latest reply: Mar 29, 2012 12:16 PM by Mark Malakanov (user11181920) RSS

Connecting and Accessing Oracle with SQL Server

@a*926111* Newbie
Currently Being Moderated
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.

Useful Replies are Highly Appreciated.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points