Storing Data in multiple Countries

We have a web application and have several clients who want their data to only be stored in their country.   Is there a decent way to do this without having multiple copies of the application running.
Josh_BladeAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
>> Is there a decent way to do this without having multiple copies of the application running.[?] <<

Sure, should be easy.  The app can connect to different databases based on the client location, or on whatever other criteria you want.

You can create one database/instance in the U.S. and a different one in Canada.
0
 
lcohanDatabase AnalystCommented:
You could "globalize" your app and create some sort of "mapping" between/via the Client Computer Locale and the appropriate Language you want that stored into the database. It is pretty complex but possible and your SQL backend is still one single server having unique  collation (Default Latin for instance) language for all "text" like columns, with one (or more) user DB(s).
0
 
Josh_BladeAuthor Commented:
Sorry, I was not clear in my objective.  I have clients in both the US and Canada that want their physical data stored in in their respective countries.  So the Canadian customers do not want their data stored on a server in the US.  The only think I can think of is to have multiple versions of the application running.   IE the US customers would access  us.myapp.com  and the canadians  ca.myapp.com and have the applications save to different databases in different countries.   Not an ideal solution and help would be appreciated.
0
 
lcohanConnect With a Mentor Database AnalystCommented:
"I have clients in both the US and Canada that want their physical data stored in in their respective countries. "
Just to make it 100% clear...the data must be stored into 2 separate SQL Servers in 2 separate countries? and they will NEVER ever use data from the "other" country database? That is extremely hard for me to believe if this "myapp.com" is from the same company.
What I think you may need is to rather look at replication or mirroring and see if they serve your purpose where 2 databases in 2 different SQL Servers from 2 different geographical positions are kept in sync.

http://stackoverflow.com/questions/16857615/syncing-a-database-between-multiple-sites

How to setup Snapshot Replication.  Here's a step-by-step guide:
http://www.mssqlcity.com/Articles/Replic/SetupSR/SetupSR.htm

Or Merge Replication:

http://msdn.microsoft.com/en-us/library/ms152746(v=sql.100).aspx
http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.