Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Solved
Storing Data in multiple Countries
Posted on 2014-04-01
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.
[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
Active today
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).
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.
Active today
"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
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
Active today
>> 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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
- Superb Internet
- IT Administration
- Ransomware
- Storage Software
- Databases
- Cloud Computing, Cloud Services, *Backups, *Online Backup Services, *Backup Software
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message.
In the To field, type your recipient's fax number @efaxsend.com.
You can even send a secure international fax — just include t…
Suggested Courses
Course of the Month14 days, 13 hours left to enroll
649 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.