SQL across countries
Posted on 2013-11-18
I have a development question here.
One customer has about 40 offices around the world. Several offices in areas where Internet is unreliable. Here is what I want to do or try to do.
I want to setup a master MS SQL database here in the US. Then setup a host of databases in each country that would be contributors or something like that to the main database (when they are able to connect). The server each country uses would be in their own country but it would send and receive updates from the main server here in the US.
The server in each country would not only have its own SQL database but that database would be the backend for that countries website. The website would be the same across all countries but would probably have to have country specific first level domains (.com for US, .au for Australia, .cn for China etc.).
We have software that can replicate the website across many countries, that's not really a problem. The problem I have is maintaining the database.
Any suggestions are welcome.