August 9, 2010 at 3:54 pm
I need to write an SQL procedure that can access data in an Oracle DB and insert it into an already exisiting SQL 2005 table. I have never had to extract anything from an Oracle DB, so I'm completely clueless on how/or if this can be done. Is it possible to connect to an Oracle DB using a SQL procedure?
August 10, 2010 at 7:33 am
bzabel (8/9/2010)
I need to write an SQL procedure that can access data in an Oracle DB and insert it into an already exisiting SQL 2005 table. I have never had to extract anything from an Oracle DB, so I'm completely clueless on how/or if this can be done. Is it possible to connect to an Oracle DB using a SQL procedure?
Yes it is possible, people around the world does it all the time.
Research "Linked server" and "Open query".
_____________________________________
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.August 10, 2010 at 8:00 am
If this is a one time thing, or rare thing, you could use the data import wizard in SQL Server to do it. Otherwise, I agree with Paul's advice. Openquery or Linked Servers can help you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply