This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 57.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
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
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.
SQL Data Sync as a tool is free and you can get started here.
Thanks, @Alberto Morillo for your contribution.
Regards
Geetha
Thank you for your support @GeethaThatipatri-MSFT ! Blessings!
@Alberto Morillo Hello, i have one more question please. is the SQL Data Sync process is the same as Log Shipping technology? or may i know the difference between them? thanks in advance.
Log shipping relies on restoring backup logs on another database/server. while SQL Data Sync relies on Sync Framework and a database schema created inside the databases called DSS schema to kep track of changes and keep 2 or more databases in sync.