question

ErnieDewhirst-6709 avatar image
1 Vote"
ErnieDewhirst-6709 asked AlbertoMorillo commented

Linking Azure SQL across Tenants

Is it possible to replicate a SQL database from Tenant A to Tenant B as can be done within a subscription using Geo-replication. The destination database is in Elastic Pool.

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo commented

Please consider using Azure SQL Data Sync. It allows one-direction and bi-directional sync between databases. 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:

201818-image.png

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.




image.png (21.0 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks Alberto seems to be just the thing we need.

0 Votes 0 ·
AlbertoMorillo avatar image AlbertoMorillo ErnieDewhirst-6709 ·

I am glad this makes sense in that scenario for your organization. Thank you for visiting Microsoft QA.

0 Votes 0 ·