Update sql server tables from Oracle

[Shadis]

Hi,


I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

how can i do such a thing?

Thanks

[abhaysk]

Read abt Transparent Gateways.. may be it helps..

[prav_saras]

Hi You can also use ADO connection in VB to transfer data from sql server to the Oracle.
Or
u can use the DTS of sqlserver

regards

praveen

Originally posted by Shadis
Hi,


I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

how can i do such a thing?

Thanks

[adrianomp]

Originally posted by prav_saras
Hi You can also use ADO connection in VB to transfer data from sql server to the Oracle.
Or
u can use the DTS of sqlserver

regards

praveen

Hmmm... you would need to fire the DTS job from SQL Server side, not Oracle. I can only imagine it being done on an synchronous basis, not asynchronous like a trigger on Oracle would do. Can you explain that?

Since Transparent Gateways option is licensed separately I'd consider generic connectivity of HS before, maybe it meets the requirements:

http://download-west.oracle.com/docs...gvsgc.htm#9912

[gandolf989]

Originally posted by Shadis
Hi,


I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

how can i do such a thing?

Thanks

You could write a java package, place it in the Oracle database, and have that java package take some data and insert it into a sql server database using the jdbc driver for SQL Server. Then all you would have to do is call the Java package from your trigger and pass the right information.

You could probably do the same thing with an external c program.