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
Printable View
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
Read abt Transparent Gateways.. may be it helps..
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
Quote:
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
Quote:
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
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.Quote:
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 probably do the same thing with an external c program.