From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Set up SQL Data Sync for Azure

Set up SQL Data Sync for Azure

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Set up SQL Data Sync for Azure

“

- Welcome back. This is lesson 3.7: Set up SQL Data Sync for Azure. So this is about data synchronization, and one of the ways to do that is to use Azure SQL Data Sync. Now, before we get started, I do want to point out that this is scheduled to be retired in 2027. So it'll be around a while, you still have some time, but the recommendation is to use alternative solutions such as Azure Data Factory or always on availability groups. However, we'll still cover it since it's scheduled to be around a bit and it'll still be useful. So what is SQL Data Sync? This is bi-directional data sync across the multiple databases using hub and spoke topology. The hub database must be Azure SQL database, but the member databases can be Azure SQL database or even an on-premises database. The sync database is one you create and only one per region and subscription. They cannot be deleted while sync groups exist. And the recommendation is to use a new empty database because the data sync creates tables…

Contents