Azure SQL Sync between Subscriptions

问题:

I have 2 subscriptions which have the same database and they would need to sync the data. Is this posible to achive with Azure SQL Sync.

Reason why we have 2 Subscriptions is becouse one of it is customers and other one is clients.

If this is not possible what would be the best way to sync 2 databses between azure subscriptions.

Azure SQL data sync

回答1:

This the answer provided by Microsoft Azure SQL Data Sync team:

Thanks for contacting us. We do support sync databases across subscriptions. (In fact, it is one of our use cases.)

If the other subscription also belong 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 our 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.