Create a single Azure SQL database using the Azure CLI
The Azure CLI is used to create and manage Azure resources from the command line or in scripts. This guide details using the Azure CLI to deploy an Azure SQL database in an Azure resource group in an Azure SQL Database logical server.
If you don't have an Azure subscription, create a free account before you begin.
Open Azure Cloud Shell
Azure Cloud Shell is a free, interactive shell that you can use to run the steps in this article. Common Azure tools are preinstalled and configured in Cloud Shell for you to use with your account. Just select the Copy button to copy the code, paste it in Cloud Shell, and then press Enter to run it. There are a few ways to open Cloud Shell:
|Select Try It in the upper-right corner of a code block.|
|Open 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 article requires that you are running the Azure CLI version 2.0.4 or later. Run
az --version to find the version. If you need to install or upgrade, see Install Azure CLI 2.0.
Define variables for use in the scripts in this quickstart.
# The data center and resource name for your resources export resourcegroupname = myResourceGroup export location = westeurope # The logical server name: Use a random value or replace with your own value (do not capitalize) export servername = server-$RANDOM # Set an admin login and password for your database export adminlogin = ServerAdmin export password = ChangeYourAdminPassword1 # 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" # The database name export databasename = mySampleDatabase
Create a resource group
Create an Azure resource group using the az group create command. A resource group is a logical container into which Azure resources are deployed and managed as a group. The following example creates a resource group named
myResourceGroup in the
az group create --name $resourcegroupname --location $location
Create a logical server
Create an Azure SQL Database logical server using the az sql server create command. A logical server contains a group of databases managed as a group. The following example creates a randomly named server in your resource group with an admin login named
ServerAdmin and a password of
ChangeYourAdminPassword1. Replace these pre-defined values as desired.
az sql server create --name $servername --resource-group $resourcegroupname --location $location \ --admin-user $adminlogin --admin-password $password
Configure a server firewall rule
Create an Azure SQL Database server-level firewall rule using the az sql server firewall create command. A server-level firewall rule allows an external application, such as SQL Server Management Studio or the SQLCMD utility to connect to a SQL database through the SQL Database service firewall. In the following example, the firewall is only opened for other Azure resources. To enable external connectivity, change the IP address to an appropriate address for your environment. To open all IP addresses, use 0.0.0.0 as the starting IP address and 255.255.255.255 as the ending address.
az sql server firewall-rule create --resource-group $resourcegroupname --server $servername \ -n AllowYourIp --start-ip-address $startip --end-ip-address $endip
SQL Database communicates over port 1433. If you are trying to connect from within a corporate network, outbound traffic over port 1433 may not be allowed by your network's firewall. If so, you will not be able to connect to your Azure SQL Database server unless your IT department opens port 1433.
Create a database in the server with sample data
Create a database with an S0 performance level in the server using the az sql db create command. The following example creates a database called
mySampleDatabase and loads the AdventureWorksLT sample data into this database. Replace these predefined values as desired (other quickstarts in this collection build upon the values in this quickstart).
az sql db create --resource-group $resourcegroupname --server $servername \ --name $databasename --sample-name AdventureWorksLT --service-objective S0
Clean up resources
Other quickstarts in this collection build upon this quickstart.
If you plan to continue on to work with subsequent quickstarts, do not clean up the resources created in this quickstart. If you do not plan to continue, use the following steps to delete all resources created by this quickstart in the Azure portal.
az group delete --name $resourcegroupname
- Now that you have a database, you can connect and query using one of your favorite tools or languages.
- To learn how to design your first database, create tables, and insert data, see one of these tutorials: