[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Link SQL Servers or link SQL databases

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
Idarac
Asked:
Idarac
1 Solution
 
Jerry MillerCommented:
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
 
tjc123IT DirectorCommented:
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
 
IdaracAuthor Commented:
Thank you
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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