Oracle to SQL Server 2k5 replication

  • Mohammad Mazharuddin Ehsan

    SSCarpal Tunnel

    Points: 4548

    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

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]

  • Greg Grow

    SSCrazy

    Points: 2386

    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

  • Bajrang

    SSCrazy

    Points: 2074

    I am also looking for this... Can someone help!!!!

    -RP
  • PaulB-TheOneAndOnly

    SSC Guru

    Points: 66773

    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.
  • snehasis.pattnaik 57469

    SSC Enthusiast

    Points: 122

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply