CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-sync
Dživo Jelić
Dživo Jelić

Reputation: 2152

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

Upvotes: 3

Views: 2348

Answers (2)

Bern
Bern

Reputation: 7951

I believe you can as noted in Microsoft's SQL Data Sync documentation.

enter image description here

Upvotes: 1

Alberto Morillo
Alberto Morillo

Reputation: 15702

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:

enter image description here

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.

Upvotes: 5

Related Questions