Solved

SQL across countries

Posted on 2013-11-18
5
231 Views
Last Modified: 2013-11-20
Hey guys

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.
0
Comment
Question by:jonmenefee
  • 2
  • 2
5 Comments
 
LVL 3

Expert Comment

by:Sagir87
ID: 39658578
Hi,

If your databases so important you should perform SQL Server full backup , Differential backup and then transaction log backup to restore databases point in time recovery.

You can prefer SQL Server transaction replication OR merge replication for maintaining databases.
0
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39658692
Merge replication is going to be your only real option if you need two way communication. Either that or transactional replication/log shipping with a separate process to pull changes and feed them back to the main database.

Replication offers the advantage that you can apply filters to the subscriber so you only send geographically relevant data to each site.
0
 

Author Comment

by:jonmenefee
ID: 39659398
Can you do merge replication over open Internet or do you have to have VPN tying all the sites together?
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39660137
You can technically do it over the internet, but if you can you would want it to be over a VPN connection - or a SSL connection at the very least if you are going the internet route.
0
 

Author Comment

by:jonmenefee
ID: 39664595
Thanks guys, much appreciated :-)
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exchange 2010 SP3 and Outlook 2003 7 31
SQL Field Length for Email Address 3 17
SSRS troubles 4 20
Common Records between Sub Queries 4 10
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Find out what you should include to make the best professional email signature for your organization.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now