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