If you close the "Refresh Schema blade" and do Refresh Logs on the sync group blade you may have an error message with more details.
Azure SQL Data Sync
Hi Team,
In Azure SQL Data Sync, inside sync group if I select a database and click on Refresh Schema, table never loads,
message appears as Load tables.
Could you please let me know how to resolve this.
Thanks,
Salil
2 answers
Sort by: Most helpful
-
-
SUNOJ KUMAR YELURU 13,941 Reputation points MVP
2021-03-27T01:07:08.403+00:00 Avoid schema refresh timeout
If you have a complex schema to sync, you may encounter an "operation timeout" during a schema refresh if the sync metadata database has a lower SKU (example: basic).Solution
To mitigate this issue, please scale up your sync metadata database to have a higher SKU, such as S3.
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-best-practicesTroubleshoot issues with SQL Data Sync
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshootLimitations
- Tables with a primary key can only be replicated
- User-defined data types are not supported
- Computed columns are not supported
- Tables with identity column which is non-primary key are not supported in Azure SQL data sync
- Tables with the same name but different schema are not supported
- You must manage identity columns manually. No auto identity management like in SQL Server replication. In case if you insert a row with the same identity value on hub and master, the insert will be lost based on your conflict resolution
- Supports only data sync not the schema changes. For example, if you insert a row in member database with identity value 1 and there is an insert with same identity value on hub database, if the conflict resolution is set to member win then the row inserted at the Azure SQL hub database is deleted and row inserted at member will be persisted in both member and hub databases
- The initial sync will only create a table on the member database, not the other objects created on top of the table like triggers, foreign keys, etc.
- Continuous synchronization is not supported. The minimum sync frequency interval is 5 minutes
https://www.sqlshack.com/azure-sql-data-sync-replicate-data-and-schema-changes-between-azure-sql-databases/
If the Answer is helpful, please click
Accept Answer
and up-vote, this can be beneficial to other community members.