How to sync local server database to cloud server database

Question

Hello,

We have a web application. Front end is in angular 8 and backend is in asp.net mvc 5 and database is mysql.

Many of our clients have internet problem. So, we are thinking like, we will save/update all transactions on local server and after some time interval we will update or sync that local server DB to cloud server DB. 

 

We will check which data is changed on local server and we will update only that data on cloud server.

We have almost 40 tables in mysql database. Can we sync whole local database with cloud server database?

Does anyone has any idea about how to do this in C#.net?  

Thank you.