move-database-between-elastic-pools-cli.md

title	Azure CLI example: Move a database between elastic pools
description	Use this Azure CLI example script to create two elastic pools and move a database in SQL Database from one elastic pool to another.
author	arvindshmicrosoft
ms.author	arvindsh
ms.reviewer	wiassaf, mathoma
ms.date	01/26/2022
ms.service	sql-database
ms.subservice	elastic-pools
ms.topic	sample
ms.custom	sqldbrb=1 devx-track-azurecli
ms.devlang	azurecli

Move a database in SQL Database in a SQL elastic pool using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates two elastic pools, moves a pooled database in SQL Database from one SQL elastic pool into another SQL elastic pool, and then moves the pooled database out of the SQL elastic pool to be a single database in SQL Database.

[!INCLUDE quickstarts-free-trial-note]

[!INCLUDE azure-cli-prepare-your-environment.md]

Sample script

[!INCLUDE cli-launch-cloud-shell-sign-in.md]

Run the script

:::code language="azurecli" source="~/../azure_cli_scripts/sql-database/move-database-between-pools/move-database-between-pools.sh" id="FullScript":::

Clean up resources

[!INCLUDE cli-clean-up-resources.md]

az group delete --name $resourceGroup

Sample reference

This script uses the following commands. Each command in the table links to command-specific documentation.

Command	Description
az sql server	Server commands.
az sql elastic-pools	Elastic pool commands.
az sql db	Database commands.

Next steps

For more information on Azure CLI, see Azure CLI documentation.

Additional SQL Database CLI script samples can be found in the Azure SQL Database documentation.