-
Update sql server tables from Oracle
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..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Re: Update sql server tables from Oracle
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
-
Re: Re: Update sql server tables from Oracle
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
An ounce of action is worth a ton of theory.
—Friedrich Engels
-
Re: Update sql server tables from Oracle
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|