Use CLI to create a single Azure SQL database and configure a firewall rule
This Azure CLI script example creates an Azure SQL database and configure a server-level firewall rule. Once the script has been successfully run, the SQL Database can be accessed from all Azure services and the configured IP address.
Open Azure Cloud Shell
Azure Cloud Shell is an interactive shell environment hosted in Azure and used through your browse. Azure Cloud Shell allows you to
PowerShell shells to run a variety of tools to work with Azure services. Azure Cloud Shell comes pre-installed with the commands
to allow you to run the content of this article without having to install anything on your local environment.
To run any code contained in this article on Azure Cloud Shell, open a Cloud Shell session, use the Copy button on a code block to copy the code, and paste it into the Cloud Shell session with Ctrl+Shift+V on Windows and Linux, or Cmd+Shift+V on macOS. Pasted text is not automatically executed, so press Enter to run code.
You can launch Azure Cloud Shell with:
|Select Try It in the upper-right corner of a code block. This doesn't automatically copy text to Cloud Shell.|
|Open Azure Cloud Shell in your browser.|
|Select the Cloud Shell button on the menu in the upper-right corner of the Azure portal.|
If you choose to install and use the CLI locally, this topic requires that you are running the Azure CLI version 2.0 or later. Run
az --version to find the version. If you need to install or upgrade, see Install the Azure CLI.
#!/bin/bash # Set an admin login and password for your database export adminlogin=ServerAdmin export password=ChangeYourAdminPassword1 # The logical server name has to be unique in the system export servername=server-$RANDOM # The ip address range that you want to allow to access your DB export startip=0.0.0.0 export endip=0.0.0.0 # Create a resource group az group create \ --name myResourceGroup \ --location westeurope # Create a logical server in the resource group az sql server create \ --name $servername \ --resource-group myResourceGroup \ --location westeurope \ --admin-user $adminlogin \ --admin-password $password # Configure a firewall rule for the server az sql server firewall-rule create \ --resource-group myResourceGroup \ --server $servername \ -n AllowYourIp \ --start-ip-address $startip \ --end-ip-address $endip # Create a database in the server with zone redundancy as true az sql db create \ --resource-group myResourceGroup \ --server $servername \ --name mySampleDatabase \ --sample-name AdventureWorksLT \ --service-objective S0 \ --zone-redundant # Update database and set zone redundancy as false az sql db update \ --resource-group myResourceGroup \ --server $servername \ --name mySampleDatabase \ --zone-redundant false
Clean up deployment
Use the following command to remove the resource group and all resources associated with it.
az group delete --name myResourceGroup
This script uses the following commands. Each command in the table links to command specific documentation.
|az group create||Creates a resource group in which all resources are stored.|
|az sql server create||Creates a SQL Database server that hosts a single database or elastic pool.|
|az sql server firewall create||Creates a firewall rule to allow access to all single databases an elastic pools on the SQL Database server from the entered IP address range.|
|az sql db create||Creates a single database or elastic pool.|
|az group delete||Deletes a resource group including all nested resources.|
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.
Send feedback about: