Solved

Link SQL Servers or link SQL databases

Posted on 2013-02-05
3
165 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 500 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now