Solved

SQL Server DB Links

Posted on 2014-03-21
2
559 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

749 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