• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 611
  • Last Modified:

SQL Server DB Links

Does SQL Server have any albternative to Oracles dba_db_links:


And if so is there anyway to see what inbound and outbound links are permitted/permissions and accounts involved etc.
2 Solutions
Carl TawnSystems and Integration DeveloperCommented:
It sounds like the Oracle db links are similar to SQL Server Linked Servers: http://technet.microsoft.com/en-us/library/ms188279.aspx

In so much as they provide a mechanism for linking to other databases (potentially external to the SQL Server) and include them in queries.
Ryan McCauleyData and Analytics ManagerCommented:
Linked servers do appear to be the closest analogy to that feature in Oracle. However, the concept of a database in Oracle and SQL are a bit different - in Oracle, each database requires its own instance of Oracle, where in SQL you can access data in other databases (located on the same instance) without any special arrangements at all. If you want to access data that's located in a separate instance of SQL Server, that's when you'd need a linked server. Also, linked servers can be to any type of database that's supported by a registered local OLEDB driver (for example, to Oracle or MySQL), where Oracle DB links appear to only allow connectivity to another Oracle server.

When you set up a linked server, you have a couple of choices - you can provide credentials that are used to connect to the remote server, or you can tell the linked server to pass the current user's credentials when connecting to the remote server. You can see which option is chosen by viewing the properties of the linked server.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now