Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are about to set up SQL Servers in different countries. We need to link them, but we don't have to have a direct link (as in linked server). In other words, they can be loosely coupled.

Is it better to connect them via a VPN and have them as linked servers, or use loose coupling via web services?

By "better", I am referring to stability.

share|improve this question
VPN sounds better than web services . – poelinca Jan 4 '11 at 15:03
Are VPNs generally stable? – IamIC Jan 4 '11 at 15:07
I would say it realy depends on how you setup things , however i would never trust a web service . – poelinca Jan 4 '11 at 15:28
I'm guessing how reliable the network is between the places is likely a factor, as I don't know how fault tolerant a linked server would be, but I know I could write it into the webservice code. – Joe Jan 4 '11 at 15:34
@poelinca I'm guessing you don't write web services then? – jcolebrand Jan 7 '11 at 1:53
up vote 9 down vote accepted

VPNs are definitely more secure than web services. As far as stability goes, as long as the VPN is set up correctly and the network doesn't go down in either location, VPNs are stable.

share|improve this answer
Out of interest, will a linked server auto-reconnect when a network drops & recovers? – IamIC Jan 4 '11 at 16:19
@IanC - Not positive, but I think it depends on what kind of DB you are running. – divided Jan 4 '11 at 21:52
it would be SQL Server 2008. – IamIC Jan 4 '11 at 21:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.