How do I put a trigger on a MSSQL database that will update an Oracle database. I suppose you would need an ODBC connection, then what?
Printable View
How do I put a trigger on a MSSQL database that will update an Oracle database. I suppose you would need an ODBC connection, then what?
You can try using a linked server in sql server.
Check sp_addinkedserver in BOL
Can you be more specific?
For creating linked server here is article.
http://www.databasejournal.com/featu...le.php/1756161