Want to move Azure sql databases from one subscription tenant to another subscription tenant

Question

We have a Azure SQL databases configured in Elastic pools and also failover group configured on it. The primary server is in one resource group and secondary server is in another resource group. Our requirement is, we need to move those databases to the other subscription(tenant) . Can we move the Azure SQL server directly to the other tenant? Also, can we do this movement without breaking the failover groups? will there any impact as Azure SQL servers are placed in different resource groups? Also what about point-in time backups(PITR) as well as Long term retention backups(LTR)

Please provide your valuable inputs to perform this task.

Answer 1

Hello Shannu,

Just go to the go to the server blade in the portal and click on Move, and then click on "Move to another subscription".

Make sure you are added as administrator on both subscriptions. If your Microsoft account is set to as administrator and you still cannot see the subscription them much probably you have different account types (Work/School and personal). In this case please open a support case.

The portal will alert you in case any dependency needs to be removed or any blocker arise that not allow a safely move. Long-term backup retention is one of the possible dependencies that need to be removed to allow the movement.