Replication from Oracle to SQL

  • Has anyone perfomed this yet.  We are trying to decide if it is an undertaking we are willing to take.  Our current concerns are a degradation of performance on the Oracle side, unreplicated data and columntype differences.

    Any comments or advice would be appreciated.

    Thanks in advance

  • In sql 2005 EE you can configure oracle as publisher...

    See BOL topic "Configuring an Oracle Publisher "

    MohammedU
    Microsoft SQL Server MVP

  • We attempted this several years ago when 10g just came out. You may what to take a close look at BLOB objects coming from Oracle to SQL if you have any. We, and Oracle, had issues with this that were show stoppers.

    Regards,

    Charles Deaton
    President
    Detroit SQL User Group

     
     

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

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