12

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.

7
  • VPN sounds better than web services .
    – poelinca
    Jan 4, 2011 at 15:03
  • Are VPNs generally stable?
    – IamIC
    Jan 4, 2011 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, 2011 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, 2011 at 15:34
  • @poelinca I'm guessing you don't write web services then?
    – jcolebrand
    Jan 7, 2011 at 1:53

1 Answer 1

9

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.

3
  • Out of interest, will a linked server auto-reconnect when a network drops & recovers?
    – IamIC
    Jan 4, 2011 at 16:19
  • @IanC - Not positive, but I think it depends on what kind of DB you are running.
    – divided
    Jan 4, 2011 at 21:52
  • it would be SQL Server 2008.
    – IamIC
    Jan 4, 2011 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.