From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 1 The Azure Data Platform

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Set up SQL Data Sync for Azure

Set up SQL Data Sync for Azure

- [Instructor] If you have multiple SQL Server databases, you can keep all of your data synchronized between them by leveraging a new feature called SQL Data Sync for Azure. SQL Data Sync provides benefits in a couple of common scenarios. First, it's not uncommon for organizations to leverage a hybrid environment these days to get the best performance from their database infrastructure. A hybrid environment places some resources in the cloud and integrates those with other resources that are installed on premises. SQL Data Sync can ensure that all of these systems can be kept synchronized so that they're all working with the same state of the data. Synchronized data is also important when you use multiple cloud-hosted databases distributed around the globe. Again, SQL Data Sync will ensure that everyone is working with the same set of data regardless of what region they're connected to. And finally, for distributed application workloads that rely on leveraging separate servers for…

Contents