I need to figure out best way to address data syncing between database on SQL VM (in Azure env) and On premises sql databases.
We are going to have 6 different locations in china with on site SQL Servers and we will have one central SQL Server in Azure cloud to keep master data. They all will be connected through point-to-site vpn. On nightly basis, we will be feeding Onsite servers (inserts to table) from cloud server. and every 15 minutes, we need to update cloud server with changes that happened onSite server.
What is the best way to do it considering performance and lock situation on cloud server.