I have a little situation - I need to read from an Oracle database and populate SQL Server tables with the info received from Oracle - is there anyway to read from and Oracle DB from within SQL Server?
What you are looking to do is create a linked server. Using ODBC you can create a linked server using the sp_addlinkedserver stored procedure. You then create a login for the server using the sp_addlinkedsrvlogin.
The last set is to create a view based on the linked server. For more information you can check out "Creating Heterogenous Query with Microsoft SQL Server 7.0" in the MS Knowledge Base. This document will give you step by step instructions for working with Ocacle data from within SQL Sever.
Good Luck
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.