SQL DB copy on web as central copy
Posted on 2013-11-21
I have a requirement and need to understand best options for that.
I am working on a desktop application which uses SQL server DB. DB is suppose to be on local machine or network, but there will be one copy on remote sql server which should have all the local updates as well.
So lets say on location1 i am working on application and making some changes in data...when i go to location 2 where this application is also installed with its local DB it should have the same data. Which i understand has to go through common medium. So one option is to have a common web DB copy on remote sql server and both these machines DB to be synced with the web copy.
Second option could be that all locations use directly remote SQL copy but that can have speed issues and that's why my client would prefer a local copy while using the application so he can work fast.
Any suggestion or inputs what would be the right way to meet this requirement.