Solved

SQL Server DB Links

Posted on 2014-03-21
2
552 Views
Last Modified: 2014-03-24
Does SQL Server have any albternative to Oracles dba_db_links:

http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3086.htm

And if so is there anyway to see what inbound and outbound links are permitted/permissions and accounts involved etc.
0
Comment
Question by:pma111
2 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 250 total points
ID: 39944871
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.
0
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 250 total points
ID: 39946868
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.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 - Merge Replication Issue 1 22
Sql Server group by 10 27
Query to capture 5 and 9 digit zip code? 4 20
SQL Query assistance 16 26
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question