getting data from oracle table to sql server table

• Sachin Vaidya

  Ten Centuries

  Points: 1273

  More actions

  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

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  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.