Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication to Oracle 11g, Help!!! Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 9:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 6, 2013 1:02 AM
Points: 3, Visits: 30
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?
Post #1441092
Posted Friday, April 12, 2013 11:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 24, 2014 7:14 AM
Points: 1,157, Visits: 3,268
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

Post #1441816
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse