Solved

Storing Data in multiple Countries

Posted on 2014-04-01
5
52 Views
Last Modified: 2016-06-04
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.
0
Comment
Question by:Josh_Blade
[X]
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
  • 2
5 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39970061
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
 

Author Comment

by:Josh_Blade
ID: 39970185
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
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 250 total points
ID: 39970243
"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
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 250 total points
ID: 39970674
>> 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

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
The next five years are sure to bring developments that are just astonishing, and we will continue to try to find the balance between connectivity and security. Here are five major technological developments from the last five years and some predict…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Both in life and business – not all partnerships are created equal. Spend 30 short minutes with us to learn:   • Key questions to ask when considering a partnership to accelerate your business into the cloud • Pitfalls and mistakes other partners…

733 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