April 10, 2013 at 9:10 pm
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?
April 12, 2013 at 11:32 am
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 @sqlscribeViewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply