Linking Azure SQL across Tenants

Ernie Dewhirst 26 Reputation points
2022-05-13T14:16:07.383+00:00

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
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,716 Reputation points MVP
    2022-05-13T14:24:25.31+00:00

    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.


0 additional answers

Sort by: Most helpful