'Two way sync data between SQL Server on localhost and cloud-based SQL Server
I have a SQL Server 2008 R2 database in local pc, and have another SQL Server 2016 database on cloud. I am not using Azure, AWS and etc..., it's just a simple SQL Server hosting on internet as cloud.
Update the local database is by .NET Winform application, and update the cloud-based database is by .NET Web application.
I have a table "Person" in local db with column "ID,Name,Gender,Contact", and a table "Person" in cloud db with column "ID,Contact".
When local user edit the person's "Contact", will sync to cloud person's "Contact". On the other hand, admin edit person's contact from cloud will sync back to local person's contact as well.
NO NEED to sync whole table. That's is because the name and gender was set in local is won't change anymore.
When local pc internet down, user still able edit and save local data, and will auto sync to cloud again once internet resume, and sync back any changes was done by admin from cloud db to local db as well.
May I know any idea or any tools to achieve this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|