1

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 .

Improve this question
5
  • By SQL, do you mean SQL Server?
    – Mark Sinkinson
    Jun 8, 2014 at 17:49
  • yes SQL SERVER .
    – user2404431
    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
    Jun 8, 2014 at 18:46
  • i am trying to do this as a client (SSMS)
    – user2404431
    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.
    – Justin Cave
    Feb 28, 2015 at 3:04

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

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

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