How to backup and sync MSSQL local database to azure database automatically

Kaung Htet Naing 46 Reputation points
2022-01-21T09:17:53.857+00:00

We have a local MSSQL database that has millions of records that are cleaned and use for reporting purpose. it will get update with more records whenever there are new databases etc. our concern is that the one who doing data cleaning and updating main database may do mistake or errors and we would like to back it up like every 3 days in azure database. we don't want to export local db and do backup because some backup file may got corrupted and our data might lost forever. so we want to buy a cloud database in azure and sync the local with cloud db. What is the best solution to solve this problem? and i want to do it automatically. Please help me. Thanks in advance

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,806 Reputation points MVP
    2022-01-21T21:23:19.84+00:00

    You can use Azure SQL Data Sync to sync your local SQL Server database to an Azure SQL Database. You can set the sync manually or automatic with a frequency up to 30 days.

    167258-image.png

    SQL Data Sync as a tool is free and you can get started here.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful