Azure data sync tables are not updated on portal

Question

I have added two tables to sync-group through power shell script. But the tables are not selected in table list. I refreshed schema , still the tables add to sync-group is not selected.

Answer 1

Hi @Aparna Manoharan,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

We would like to inform you that, If you are still facing the same issue then please follow the below mentioned troubleshooting steps:

1. Schema Refresh Completeness: Sometimes, the schema refresh doesn’t immediately detect new tables. Try a manual schema refresh through the Azure portal. This may force a re-sync of all table information. If available, use the "Refresh Schema" button within the Sync Group settings in the portal to see if the tables show up.
2. Table Compatibility: Ensure that the tables you are trying to add meet Azure SQL Data Sync requirements. Tables in a sync group must have a primary key, and they need to comply with supported data types. Unsupported data types or missing primary keys can prevent tables from being added to the sync group.
3. PowerShell Script Verification: Double-check the PowerShell script to confirm that the tables were added successfully. You can verify the sync group’s schema configuration by using the Get-AzSqlSyncGroupSchema command to confirm that the tables are indeed recognized within the sync group.
4. Sync Metadata Update: Sometimes, sync metadata may not update immediately. You can try removing and re-adding the tables to the sync group to see if they appear in the list.
5. Permissions Check: Ensure that your Azure account and any service principal or managed identity running the PowerShell script have sufficient permissions to modify the sync group and refresh schemas.

We request you to refer the below mentioned links for more information.

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-best-practices?view=azuresql#table-considerations-and-constraints

https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/update-sync-schema-in-sync-group?view=azuresql

https://github.com/microsoft/sql-server-samples/blob/master/samples/features/sql-data-sync/UpdateSyncSchema.ps1

https://github.com/MicrosoftDocs/sql-docs/blob/live/azure-sql/database/scripts/update-sync-schema-in-sync-group.md

I hope, This response will address your query and helped you to overcome on your challenges.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.