Azure SQL Data Sync

salil singh 196 Reputation points
2021-03-26T14:47:22.203+00:00

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
{count} votes

2 answers

Sort by: Most helpful
  1. SUNOJ KUMAR YELURU 12,411 Reputation points Microsoft MVP
    2021-03-27T01:07:08.403+00:00

    HI @salil singh

    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-practices

    Troubleshoot issues with SQL Data Sync
    https://learn.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.

    No comments

  2. Vitor Tomaz 1 Reputation point Microsoft Employee
    2021-03-28T11:54:51.25+00:00

    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.

    No comments