CODEWITHSUNDEEP
sql-serverazureazure-sql-database
Presi
Presi

Reputation: 827

SQL Data Sync with Azure do not show my database

I want to configure the SQL Data Sync for my Azure SQL Database. So I opened the tutorial from Microsoft (https://learn.microsoft.com/en-us/azure/sql-database/sql-database-get-started-sql-data-sync).

Azure SQL configuration

I have selected my Azure SQL Server, but when I want to select my Database theres only the master. And this is the wrong one. I have created another. Anyone knows how to show my database there?

Upvotes: 1

Views: 826

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

If you only have created one database, actually you have two database, master db and other database. That's same with me:

enter image description here

You can not choose the same database as the member database, only the master db you can choose. Add member database: enter image description here

SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bi-directionally across multiple SQL databases and SQL Server instances.

This means that you can sync the data between the database in same Azure SQL server or other. enter image description here

For your question, You want use the same database for metadata and my sync data, I think you may think about using Azure Data Factory, Data Factory support you choose the same database both as source dataset and Sink dataset.

Here's the tutorial: Copy data to or from Azure SQL Database by using Azure Data Factory.

I think it can help you achieve your purpose.

Hope this helps.

Upvotes: 1

Related Questions