Skip to content

scale-pool-cli.md

Latest commit

 

History

History
56 lines (38 loc) · 1.85 KB

scale-pool-cli.md

File metadata and controls

56 lines (38 loc) · 1.85 KB
title Azure CLI example: Scale an elastic pool
description Use an Azure CLI example script to scale an elastic pool in Azure SQL Database.
services sql-database
ms.service sql-database
ms.subservice elastic-pools
ms.custom sqldbrb=1, devx-track-azurecli
ms.devlang azurecli
ms.topic sample
author arvindshmicrosoft
ms.author arvindsh
ms.reviewer kendralittle, mathoma
ms.date 01/26/2022

Scale an elastic pool in Azure SQL Database using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates elastic pools in Azure SQL Database, moves pooled databases, and changes elastic pool compute sizes.

[!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/scale-pool/scale-pool.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 db Database commands.
az sql elastic-pools Elastic pool commands.

Next steps

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

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