Hello,

Have a look at any MS SQL related Sync software. Just set up MS SQL as source and target database.

You can schedule sync job running daily.

Trigger based sync reflects changes made in one databases to another databases.

Bidirectional db sync is available as well.