I have two servers, Oracle and SQL-Server.

I have same database on both the servers.

I want to perform DML (insert,update,delete).

How can I perform same DML statements on both the servers simultaneously ?

If I insert one statement in SQL-Server then the same statement should be updated in the Oracle database .

  • By SQL, do you mean SQL Server? Commented Jun 8, 2014 at 17:49
  • yes SQL SERVER . Commented Jun 8, 2014 at 17:54
  • are you trying to do this from an application your're writing? or from some kind of client (like SSMS) that support both DBMSs?
    – joe
    Commented Jun 8, 2014 at 18:46
  • i am trying to do this as a client (SSMS) Commented Jun 9, 2014 at 5:20
  • 3
    Do you really mean simultaneously? So every transaction will incur the overhead of a two-phase commit and the system will be unusable if either database is unavailable? Generally, that's not what you want. Generally, you want to replicate data from one system to the other asynchronously which brings up the question of what sort of lag you can tolerate and whether the replication needs to be bidirectional. Commented Feb 28, 2015 at 3:04

1 Answer 1


I do not have enough reputation to write a comment so I am writing here. It may be an unswer to your question.

I have never tried, but it should work. You can add an Oracle database into your SQL Server as a linked server and then write a trigger in the sql server and perform the insert to Oracle via OpenQuery. This should be the easiest way and should work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.