Replication to Oracle 11g, Help!!!

• tsaolimkei

  SSC Rookie

  Points: 37

  More actions

  April 10, 2013 at 9:10 pm

  #394565

  I would like to replicate transaction changes from sql server (2005 & 2012) to oracle 11g, I want the transaction changes (insert, update, delete) on tables to replicate to oracle tables fast, what kind of tools in sql server can I use?

  How can I just use the transaction log from sql server and apply the delta changes to oracle database, thanks?

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  April 12, 2013 at 11:32 am

  #1606067

  tsaolimkei (4/10/2013)

  ---

  I would like to replicate transaction changes from sql server (2005 & 2012) to oracle 11g, I want the transaction changes (insert, update, delete) on tables to replicate to oracle tables fast, what kind of tools in sql server can I use?

  How can I just use the transaction log from sql server and apply the delta changes to oracle database, thanks?

  Read up on transactional replication -

  http://msdn.microsoft.com/en-us/library/ms151176.aspx

  http://msdn.microsoft.com/en-us/library/ms151864.aspx

  Tommy

  Follow @sqlscribe