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