SQL Server Performance Forum – Threads Archive

INSERT, UPDATE, or DELETE on Oracle Database from

Hi, Is it possible to INSERT, UPDATE, or DELETE on Oracle Database from MSSQL svr
May be using DTS or linked server or some think else?
Regards
Srini

using DTS, you can do data transfers, but from using Linked server yes you can do it

Hi, Can u pls tell me how to do with Linked server ?? Regrds
Srini

Check this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp

Hi, Linked server we can READ data only from oracle we cant update ,insert or delete in Oracle database pls check.’ Regards
Srini

Look for OpenRowset in BOL
Madhivanan Failing to plan is Planning to fail

Srini#
Is it a constant update of data or a one-off job? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Like to do constant update of data if Possible , is it Possible??
Srini

Is there any way we can do …

If its a constant update then DTS will come in handy as Linked Server may have issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>