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

Oracle to SQL Server 2k5 replication Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2007 1:24 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, August 3, 2014 3:03 PM
Points: 378, Visits: 2,403
Has any one implemented Oracle to SQL Server 2k5 transactional replication (Oracle as publisher and SQL Sever 2k5 as subscriber)
Please explain the steps that are taken.

Thanks,
Maz


-----------------------------------------------------------
Time Is Money
Calculating the Number of Business Hours Passed since a Point of Time
Calculating the Number of Business Hours Passed Between Two Points of Time
Post #436484
Posted Friday, January 11, 2008 9:21 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:12 PM
Points: 700, Visits: 818
I am also interested in Transaction Replication from Oracle to SQL Server 2005. Can someone offer any links, documents, information regarding Replication with these database servers?

Thanks
Greg



Post #441848
Posted Thursday, June 3, 2010 12:29 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 15, 2014 1:21 PM
Points: 670, Visits: 231
I am also looking for this... Can someone help!!!!

-RP
Post #932340
Posted Friday, June 4, 2010 1:22 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
There is a documented solution, let me quote: "Beginning with Microsoft SQL Server 2005, you can include Oracle Publishers in your replication topology, starting with Oracle version 9i. "

If this is what you are looking for please check http://msdn.microsoft.com/en-us/library/ms151229.aspx


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #933043
Posted Monday, August 19, 2013 6:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 7:57 AM
Points: 6, Visits: 78
Hi Guys

In order to replicate data from oracle 10g to SqlServer 2005 you can use follow the document present in the link below.

http://technet.microsoft.com/en-us/library/cc966428.aspx

Snehasis.
Post #1485771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse