Skip to content

create-and-configure-database-cli.md

Latest commit

 

History

History
57 lines (39 loc) · 2.07 KB

create-and-configure-database-cli.md

File metadata and controls

57 lines (39 loc) · 2.07 KB
title Azure CLI example: Create a single database
description Use this Azure CLI example script to create a single database.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer wiassaf, mathoma
ms.date 01/26/2022
ms.service sql-database
ms.subservice deployment-configuration
ms.topic sample
ms.custom
sqldbrb=1
devx-track-azurecli
ms.devlang azurecli

Create a single database and configure a firewall rule using the Azure CLI

[!INCLUDEappliesto-sqldb]

This Azure CLI script example creates a single database in Azure SQL Database and configures a server-level firewall rule. After the script has been successfully run, the database can be accessed from all Azure services and the allowed IP address range.

[!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/create-and-configure-database/create-and-configure-database.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 server firewall Server firewall 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.