Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Link SQL Servers or link SQL databases

Posted on 2013-02-05
3
Medium Priority
?
190 Views
Last Modified: 2013-04-29
I am looking for info on the following .

Link Server to Server
Link 2 databases in the same Servers.
Link 2 databases each located in a separate Server.

Is it possible to link the way you link from an ACcess database to SQL Server?
0
Comment
Question by:Idarac
3 Comments
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 2000 total points
ID: 38857760
You can use linked servers for the server to server communication:

http://msdn.microsoft.com/en-us/library/ms188279.aspx
http://msdn.microsoft.com/en-us/library/aa213778%28v=sql.80%29.aspx

As far as database to database on the same server you simply have to full qualify the table names and include the database name.
0
 
LVL 5

Expert Comment

by:tjc123
ID: 38858028
You could with server replication which allows granular selection of what databases, tables, stored procedures, etc. that you want to send to the secondary server.  Replication happens in real time.
0
 
LVL 1

Author Closing Comment

by:Idarac
ID: 39120968
Thank you
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

879 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