Post reply

Replication from Oracle to SQL

  • October 30, 2007 at 3:13 am

    #183300

    Hi,

    I would like to know if SQL server 2000 supports replication from Oracle (source) to SQL (target). If can, is there any limitation and could you guide me on the setup?

    Thanks

  • November 1, 2007 at 2:47 pm

    #747532

    When I ran into this question a few years ago while working for Microsoft, the answer was "Microsoft does not have a story for replication from Oracle to SQL 2000 (but they do for SQL 2005)." So I wrote a framework that MSNBC still uses to get election data from NBC. Because the NBC tables had standardized naming and timestamps, I was able to just read their schema every minute or two for a configurable list of tables and columns, and build a dynamic command to pull those table row/columns into an MSSQL staging table wherever the Oracle timestamp was greater than the corresponding MSSQL destination row's timestamp. It was fairly easy, self-adjusting and reliable enough that we later upgraded it to SQL2005 without changing it to use the 2005 Oracle support.

    Regards,

    Gary

  • November 2, 2007 at 1:44 am

    #747656

    Hi Gary,

    Thanks for your feedback. Meaning we have to upgrade to SQL2005 if we would like to do replication from ORACLE to SQL server.

    Anything that I should aware if I wanna do the replication from ORACLE to SQLserver 2005. Any constraint or drawback?

    Btw, apologize for my ignorance, may I know what is MSNBC?

    Cheers

  • November 2, 2007 at 7:12 am

    #747729

    What version of Oracle are you using?

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

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