question

salilsingh-9961 avatar image
0 Votes"
salilsingh-9961 asked NavtejSaini-MSFT commented

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

azure-sql-database
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@salilsingh-9961 Please let us know if you need any further help.

0 Votes 0 ·

@salilsingh-9961

We will definitely look into these issues and one has been answered by a team member. Please check those issues for more details. We will close this issue for now.

Regards
Navtej S

1 Vote 1 ·
learn2skills avatar image
0 Votes"
learn2skills answered

HI @salilsingh-9961

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://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-best-practices

Troubleshoot issues with SQL Data Sync
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot

Limitations
1. Tables with a primary key can only be replicated
2. User-defined data types are not supported
3. Computed columns are not supported
4. Tables with identity column which is non-primary key are not supported in Azure SQL data sync
5. Tables with the same name but different schema are not supported
6. 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
7. 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
8. 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.
9. 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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

vitomaz avatar image
0 Votes"
vitomaz answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.