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.