Post reply

Combining SQL Server and Oracle Data

  • May 4, 2005 at 9:00 am

    #92986

    I need to do a data extraction that corralates data from two seperate databases, an SQL Server 2000 database and an Oracle Enterprise Edition 8.05 database. Any advice on what language or tools would let me do this with the least amount of pain. I'm comfortable working in most common programing languages, but I'm new to working with SQLServer.

    Thanks for your help.

    Ellen

  • May 4, 2005 at 9:15 am

    #556801

    Ask your DBA to setup linked server to Oracle and then you can query Oracle database just like query SQL Server database.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;280106

     

  • May 5, 2005 at 8:35 am

    #557085

    The link server is a good idea, if you are comparing a amount of data then that link gets to be very slow.  Copy the data from the oracle db using the link to a temp table and compare it off of the local copy.

  • May 10, 2005 at 2:42 am

    #557752

    I agree with Rick, linked server is too slow when you need to get enormous amount of data.

    One thing i can suggest is, use Sql server Dts and get the data from Oracle db to sql server db and then compare both sql server dbs. I feel in this option it takes less time.

     

     






    Regards,
    Sudheer 

    My Blog

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

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