sql-server - SQL Data Sync with Azure do not show my database

Question

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

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?

标签： sql-serverazureazure-sql-database

Answer 1

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

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

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.

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.