Azure SQL DB Sync with other databases is greyed out

Question

I'm working through this tutorial https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql but I can't get passed step 3. In Azure I select the sql db and on the left under Data Management I can see Sync with other databases but it is greyed out so not an option.

I used this tutorial to create the db in the first place https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?view=azuresql&tabs=azure-portal

I'm sure it's a settings thing, but I can't find anything online.

Answer 1

Hi @Janet Putnam

Here is a note for Azure SQL DB Sync

• Note: If you already configured the sync group, then the option “sync metadata database” field will be greyed out. Azure data sync will only allow having one Data Sync for any Azure region.

Let us consider an example, the server “Azuredb1” hosted in Region -South Central US and you configure the Azure Data Sync. For the first time, it is allowed to configure metadata database “azuredatasync” if at all there is no prior azure data sync configuration

Now, if you try to configure Azure Data Sync service for another server “Azuredb2” which is located in South Central US then you will have default azuredatasync on sqldb. By default, the option is greyed out.

In case if you want to create an Azure Data sync service, then you need to delete the underlying configuration and sync the metadata database azuredb1 completely or start building the solution in the new region.

Thank you!