I am trying to sync my offline site database to the online site database. The architecture as such is because of the fact our internet connection is mostly blocked in our state. As a result, I will be having the same application deployed locally as well as
have one online. I am in this regard looking to sync these databases accordingly and have come up with the following solutions.
Microsoft Sync Tool.
Use the self-written Custom Code based on Row Versions.
I am looking for a solution that's optimal and works in maintaining the data consistency across the two databases. If there is any other better way of accomplishing this task please let me know.
Thanking you in anticipation.
Kind Regards.
Software Developer
Techvity IT Services
http://techvityit.com
assuming you use MS SQL server as your DB, it seems
Ms Sync is a decent choice. I'd at least give it a go first before diving into rabbit hole of crafting your custom solution
Member
1 Points
73 Posts
Database Synchronisation
Mar 27, 2020 07:06 PM|fahrabh|LINK
Hello,
I am trying to sync my offline site database to the online site database. The architecture as such is because of the fact our internet connection is mostly blocked in our state. As a result, I will be having the same application deployed locally as well as have one online. I am in this regard looking to sync these databases accordingly and have come up with the following solutions.
I am looking for a solution that's optimal and works in maintaining the data consistency across the two databases. If there is any other better way of accomplishing this task please let me know.
Thanking you in anticipation.
Kind Regards.
Techvity IT Services
http://techvityit.com
Member
170 Points
96 Posts
Re: Database Synchronisation
Mar 27, 2020 09:19 PM|timur.kh|LINK
assuming you use MS SQL server as your DB, it seems Ms Sync is a decent choice. I'd at least give it a go first before diving into rabbit hole of crafting your custom solution