How to move Azure Elastic Pool between different SQL Servers

Question

I'm looking to move Azure Elastic Pool from one Azure SQL Server to another Azure SQL Server.

I'm not sure if its possible to do so, as I tried to look around internet for the same but couldn't find any information.

Please suggest any approach to do so if its feasible (within the same subscription or into different subscription as well).

Thanks in advance

Answer 1

I tool that is worthy to try on this scenario is Azure Resource Mover. It supports Azure SQL Elastic Pools as you can read here.

If the tool does not help, then create the new Azure SQL logical Server, on the newly created server now create a new Azure SQL Elastic Pool, the move the database from one elastic pool to the other using CLI.

# Get the database ID
dbId=$(az sql db show --resource-group myResourceGroup --server myserver1 --name mydb --query id --output tsv)

# Move the database to the new elastic pool
az sql db update --ids $dbId --elastic-pool mypool --server myserver2

Please read this documentation for more detailed steps.