Post reply

getting data from oracle table to sql server table

  • July 20, 2011 at 4:41 am

    #241679

    Hello,

    I want to read the data from a oracle db table into a sql server db table. I heard that this can be done by setting up a db link (and providing appropriate permissions). Can someone provide more details on this please?

    I can do it using SSIS package but I want to use some other way.

    Regards

  • July 26, 2011 at 2:56 pm

    #1358859

    Sachin Vaidya (7/20/2011)

    I want to read the data from a oracle db table into a sql server db table. I heard that this can be done by setting up a db link (and providing appropriate permissions). Can someone provide more details on this please?

    Sure... 1) Setup Link, 2) Issue query thru Link.

    For details nothing beats Microsoft documentation, I would start here: http://support.microsoft.com/kb/280106

    _____________________________________
    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.

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

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