Ask: Is there a way to write data to the ORACLE database in the SQL Server trigger?

garyellie

As the title

vgf10002

Theoretically it is possible

money80100

Link server

kxiaper

Similar to this:
USE master
GO
EXEC sp_addlinkedserver
   'svr_lnk',
   'Oracle',
   'MSDAORA',
   'MyServer'
GO
EXEC sp_addlinkedsrvlogin 'LONDON Mktg', 'false', 'sa', 'Admin', NULL
GO
CREATE TRIGGER TR_1 ON TABLE1
AS
INSERT svr_lnk.dbname.dbo.table2 value (...)

kxiaper

Similar to this:
USE master
GO
EXEC sp_addlinkedserver
   'svr_lnk',
   'Oracle',
   'MSDAORA',
   'MyServer'
GO
EXEC sp_addlinkedsrvlogin 'svr_lnk', 'false', 'sa', 'Admin', NULL
GO
CREATE TRIGGER TR_1 ON TABLE1
AS
INSERT svr_lnk.dbname.dbo.table2 value (...)

cinaese

Can triggers cross servers?
A post on the top of the road