Reputation: 2143
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.
Upvotes: 3
Views: 2346
Reputation: 7951
I believe you can as noted in Microsoft's SQL Data Sync documentation.
Upvotes: 1
Reputation: 15698
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.
Upvotes: 5