Quickstart: Create a single database in Azure SQL Database using an ARM template

  • Article
  • 2 minutes to read

Creating a single database is the quickest and simplest option for creating a database in Azure SQL Database. This quickstart shows you how to create a unmarried database using an Azure Resource Manager template (ARM template).

An ARM template is a JavaScript Object Note (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax. In declarative syntax, you describe your intended deployment without writing the sequence of programming commands to create the deployment.

If your environment meets the prerequisites and you're familiar with using ARM templates, select the Deploy to Azure push button. The template will open in the Azure portal.

Deploy to Azure

Prerequisites

If you don't have an Azure subscription, create a free account.

Review the template

A single database has a defined set of compute, retention, IO, and storage resource using one of two purchasing models. When y'all create a single database, yous too define a server to manage it and place it within Azure resource group in a specified region.

The template used in this quickstart is from Azure Quickstart Templates.

              {   "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",   "contentVersion": "1.0.0.0",   "metadata": {     "_generator": {       "proper noun": "bicep",       "version": "0.four.1272.37030",       "templateHash": "9394105950124013475"     }   },   "parameters": {     "serverName": {       "type": "string",       "defaultValue": "[uniqueString('sql', resourceGroup().id)]",       "metadata": {         "description": "The proper noun of the SQL logical server."       }     },     "sqlDBName": {       "type": "string",       "defaultValue": "SampleDB",       "metadata": {         "clarification": "The name of the SQL Database."       }     },     "location": {       "type": "string",       "defaultValue": "[resourceGroup().location]",       "metadata": {         "description": "Location for all resource."       }     },     "administratorLogin": {       "type": "cord",       "metadata": {         "description": "The administrator username of the SQL logical server."       }     },     "administratorLoginPassword": {       "blazon": "secureString",       "metadata": {         "clarification": "The ambassador password of the SQL logical server."       }     }   },   "resources": [     {       "type": "Microsoft.Sql/servers",       "apiVersion": "2021-08-01-preview",       "name": "[parameters('serverName')]",       "location": "[parameters('location')]",       "properties": {         "administratorLogin": "[parameters('administratorLogin')]",         "administratorLoginPassword": "[parameters('administratorLoginPassword')]"       }     },     {       "blazon": "Microsoft.Sql/servers/databases",       "apiVersion": "2021-08-01-preview",       "name": "[format('{0}/{ane}', parameters('serverName'), parameters('sqlDBName'))]",       "location": "[parameters('location')]",       "sku": {         "name": "Standard",         "tier": "Standard"       },       "dependsOn": [         "[resourceId('Microsoft.Sql/servers', parameters('serverName'))]"       ]     }   ] }

These resource are defined in the template:

  • Microsoft.Sql/servers
  • Microsoft.Sql/servers/databases

More Azure SQL Database template samples can be found in Azure Quickstart Templates.

Deploy the template

Select Endeavor information technology from the following PowerShell lawmaking block to open up Azure Cloud Shell.

              $projectName = Read-Host -Prompt "Enter a project name that is used for generating resources names" $location = Read-Host -Prompt "Enter an Azure location (i.e. centralus)" $adminUser = Read-Host -Prompt "Enter the SQL server administrator username" $adminPassword = Read-Host -Prompt "Enter the SQl server administrator password" -AsSecureString  $resourceGroupName = "${projectName}rg"  New-AzResourceGroup -Name $resourceGroupName -Location $location New-AzResourceGroupDeployment -ResourceGroupName $resourceGroupName -TemplateUri "https://raw.githubusercontent.com/Azure/azure-quickstart-templates/chief/quickstarts/microsoft.sql/sql-database/azuredeploy.json" -administratorLogin $adminUser -administratorLoginPassword $adminPassword  Read-Host -Prompt "Press [ENTER] to go along ..."

Validate the deployment

To query the database, run across Query the database.

Clean up resources

Keep this resource grouping, server, and single database if you want to go to the Next steps. The adjacent steps show you lot how to connect and query your database using different methods.

To delete the resource grouping:

              $resourceGroupName = Read-Host -Prompt "Enter the Resource Group name" Remove-AzResourceGroup -Name $resourceGroupName

Adjacent steps

  • Create a server-level firewall rule to connect to the single database from on-premises or remote tools. For more data, run across Create a server-level firewall dominion.
  • After you create a server-level firewall rule, connect and query your database using several unlike tools and languages.
    • Connect and query using SQL Server Direction Studio
    • Connect and query using Azure Data Studio
  • To create a single database using the Azure CLI, run across Azure CLI samples.
  • To create a single database using Azure PowerShell, run into Azure PowerShell samples.
  • To acquire how to create ARM templates, run into Create your first template.