locked
Database Synchronisation RRS feed

  • Question

  • User-1635004321 posted

    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.

    1. Microsoft Sync Tool.
    2. 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.

    Friday, March 27, 2020 7:06 PM

All replies

  • User415553908 posted

    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

    Friday, March 27, 2020 9:19 PM