Ask the Expert

Linking SQL Server to Oracle server

How can I link SQL Server from its manager environment to an Oracle server? My idea is to get information stored in the Oracle server through SQL Server.

    Requires Free Membership to View

I do not know of any methodology which lets you link SQL Server to Oracle. Oracle does let you link to a non-Oracle database by leveraging Heterogeneous Services (HS). HS lets you query SQL Server as if it were another Oracle database. I do not know of such a product in SQL Server that lets you query Oracle directly. Instead, you will probably want to replicate the Oracle data into the SQL Server database. You can use SQL Server's Data Transformation Services (DTS) to pull the data from Oracle through an ODBC driver and store the data in SQL Server.

This was first published in May 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: