Azure SQL - Sync to other databases - 3 - Add sync members

@20aman    Nov 25, 2020

In the previous post, we saw how to create the sync group for the Azure SQL Database. If you haven’t gone through the post on how to create a sync group then please check that post first. In this post, we will learn how to add the sync members for the already created sync group.

To begin, navigate to the existing sync group and click on it to open the new blade as shown below.

Databases section under Sync groups

Click on the Databases section to add the databases as members of the sync group.

Select Sync members

Next, click on “Add an Azure Database”. Provide the following details about the target database to add it as a member for syncing.

Configure Azure Database

Once you click Ok, you will see the databases added under the "Member Database" section as shown below.

Member Database section

You can add more azure SQL databases by clicking on the “Add an Azure Database”. If you want to add the on-premises SQL database into the member database then go with the “Add an On-Premises Database” option.

Comments powered by Disqus