1

We have Azure SQL databases in the Azure Elastic pool which are configured in the failover groups. We are planning to move the elastic pool from one subscription to another subscription(to different tenant).

Is it possible to move the elastic pool configured in failover groups to another subscription(different tenant) with out breaking the failover groups.

or else please share the steps/process to perform the activity

Shannu
  • 13
  • 2

1 Answers1

1

Oki so there are two steps, you cannot move resource to a different tenant directly.

What you can do is,

  1. Create a temporary subscription in your current tenant, and move these elastic pools into that temporary subscription. see, Move resources to a new resource group or subscription

Can also use Azure resource Mover

Tutorial: Move Azure SQL Database resources to another region

enter image description here

  1. Then, you can move the temporary subscription to the other tenant. see, Transfer an Azure subscription to a different Azure AD directory
iarunpaul
  • 117
  • 2
  • 13
KarthikBhyresh-MT
  • 4,560
  • 2
  • 5
  • 12
  • Thanks for your reply.. What is the need to move the elastic pool into temporary subscription. what about the failover groups? . Moreover those databases are in production. – Shannu Nov 11 '21 at 13:57
  • In case you have other resources in your current subscription, that you don't want to move to the new tenant, you can move just these sql pool to temp subscription and attach this temp subscription to new tenant – KarthikBhyresh-MT Nov 11 '21 at 14:25
  • what a bout the failover groups. when we move the Elastic pool whether failover groups will also move to the new tenant or do we need to break the failover groups to move the elastic pool. – Shannu Nov 11 '21 at 15:10
  • Create replica server in destination subscription before move, then fail-over to replica server to move it to destination subscription – KarthikBhyresh-MT Nov 11 '21 at 15:37