SQL across the Internet
Posted on 2014-11-02
Ok, here is the scenario. My customer has 40 offices scattered around the world. They all need to access a common SQL database thru a website front end. Right now about 1/2 of them can access the database (here in the United States) with no slow downs, but the other half are experiencing slow downs due to their location (Asia, Australia etc.). So they want a solution that will enable everyone to have access to the same Data from a server that is local to them. So I looked around and since we are using Microsoft products I saw that SQL Enterprise has Peer to Peer Replication. That of course is the most expensive one (at $30,000 per 4 core VM), so I want to offer them another alternative if possible. Which of the replication models would work with this do you think? Each region would have two servers. One is a website server and the other is the database server (both are VM's). It would be nice if the data was up to date on all the servers on a constant basis but if there is a small delay of 10 or 15 minutes I think they can live with that (if we tell them up front).
So, what do you guys think? We want to stay with the most recent edition of SQL because we are using 2005 now and we want this solution to last as long as the one we have now has.