Replication from Oracle to SQL

  • Mike Clousing

    Old Hand

    Points: 364

    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

  • MohammedU

    SSCoach

    Points: 19644

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

    See BOL topic "Configuring an Oracle Publisher "

    MohammedU
    Microsoft SQL Server MVP

  • Charles Deaton

    SSC-Addicted

    Points: 422

    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