I have installed Oracle database 12c enterprise on my laptop.
How can I implement data synchronization between Oracle 12c and SQL Server 2014 that whenever an INSERT,UPDATE,DELETE or ... happend on SQL Server tables I can have it on my Oracle database automatically in the shortest time it is possible?


1 Answer 1


You have a few options:

  1. Transactional replication: this has been around for quite some time and works nicely within its narrowly defined scenario. Unfortunately, the use of non-SQL Server subscribers is deprecated.

  2. Change data capture + SSIS: this is the Microsoft recommended solution. It's a bit more involved than replication (to me anyway) but it's also more flexible. You can do some really powerful things with SSIS as the data mover, if you ever need it. Basic concepts described here with a detailed example here.

  3. Oracle solutions: you can also do it from the other end. Oracle has similar capabilities as SQL Server including their GoldenGate software. However, I believe it's extra $$$ for license. I don't think you'll need to tread this path but calling it out for completeness.

  • What about the "Oracle Database Link" and "Heterogeneous Database Gateway", Are these just another option for this issue or the cause of using them are different?
    – SajjaD
    Aug 22, 2015 at 9:43
  • And also does "Oracle Data Integrator" do the same work or not?
    – SajjaD
    Aug 22, 2015 at 17:30

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.