Take the 2-minute tour ×
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. It's 100% free, no registration required.

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? –  IanC 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

1 Answer 1

up vote 8 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? –  IanC 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. –  IanC Jan 4 '11 at 21:57

Your Answer

 
discard

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.