How to sync in Azure SQL DB from Azure China to Azure US?

Question

How to sync in Azure SQL DB from Azure China to Azure US?

Lingfu Zhang 20

We have two subscriptions, one in Azure China and the other in Azure US, both has Azure SQL database and we are trying to sync the data from Azure SQL database from Azure China to SQL database in Azure US. I know Azure data sync can sync data from on-prem SQL server to Azure SQL server as well as between the SQL databases within the same subscription. I'm wondering if there is an option to achieve data sync from Azure China to Azure US? And whether Azure data sync could be used in this scenario?

Accepted answer

0 additional answers

Your answer

Answer 1

Alberto Morillo 34,676 MVP Volunteer Moderator

Let me recommend you Azure SQL Data Sync. One of the use cases for this free tool (SQL Data Sync) is to replicate between databases on different subscriptions.

If the other subscription also belongs to the same tenant, you can directly add it by selecting a different subscription when adding Azure database:

Otherwise, probably it is better to use the PowerShell cmdlet New-AzureRmSqlSyncMember, you need to specify the “MemberServerName” parameter, which is the fully qualified DNS name for the logical server.

To see the subscriptions in portal, they must under the same tenant and the user needs to have permission to both of them. If that’s not the case, they can add the sync member using PowerShell.

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2023-03-13T21:47:10.12+00:00

Lingfu Zhang thank you for reaching out.

Please check above answer provided by @Alberto Morillo . If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Lingfu Zhang 20 Reputation points

2023-03-20T21:22:10.68+00:00

Thanks for your answer @Alberto Morillo !

In my case, China Azure and US Azure are two different tenants, so just making sure that I understand correctly. I can set up Azure SQL Data Sync in Azure China and add sync member using PowerShell from Azure US tenant and subscription where secondary database is created, right?
Alberto Morillo 34,676 Reputation points MVP Volunteer Moderator

2023-03-20T22:38:49.9566667+00:00

Hi Lingfu,

That is correct! If the databases belong to different tenants then use PowerShell to add the Sync Member as the Azure Portal won't allow you adding a database belonging to a different tenant.

Share via

How to sync in Azure SQL DB from Azure China to Azure US?

0 additional answers

Your answer