sql server – how to migrate an azure sql database to another subscription within the same tenant

how to migrate an azure sql database to another subscription in the same tenant

Scenario: I have a database server with approximately 600 databases in subscription A , I want to migrate some databases to subscription B in multiple new resource groups in the same tenant. what are the best ways that involve less downtime

What I don’t want:

  1. I will not migrate the server just the databases.
  2. it is also not feasible to export bank by bank to storage acount and import the new subscription.

I thought of azure sql replication as a solution, but I didn’t find how to do it between subscription

New-AzSqlDatabaseSecondary -PartnerResourceGroupName $secondaryResourceGroupName -PartnerServerName $secondaryServerName
-PartnerDatabaseName $database.DatabaseName -SecondaryElasticPoolName $secondarypoolname
-ResourceGroupName $primaryResourceGroupName -ServerName $primaryServerName
-BackupStorageRedundancy $BackupRedundanceLocal `
-AllowConnections “All”

The items that I found on stackoverflow also migrate sql server and that I can’t do

Read more here: Source link