how can I find data sync in SQL database menu

Yonghu shi 0 Reputation points
2024-01-29T09:14:07.3033333+00:00

I can find the data sync menu which is show in sql database document. How can I find the data sync? https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql#add-on-prem 20240129170850

Azure SQL Database
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 13,751 Reputation points Microsoft Employee
    2024-01-29T09:37:40.48+00:00

    Hi Yonghu shi •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you are unable to find option of SQL Data Sync for your Azure SQL Database.

    Thanks for the screenshot, I could see that the Pricing tier is Hyperscale.

    As general limitation of SQL Data Sync:

    Using an Azure SQL Hyperscale database as a Hub or Sync Metadata database isn't supported. However, a Hyperscale database can be a member database in a Data Sync topology.

    Reference document link: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql#general-limitations

    Please try with a different tier and sync. Let us know if you have further queries.

    Regards,

    Shakti

    0 comments No comments