Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL across countries

Posted on 2013-11-18
5
234 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Read this checklist to learn more about the 15 things you should never include in an email signature.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

792 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