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.

  • 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

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.

  • 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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