Configure customized deployment templates
In this we will learn how to create a single database using an Azure Resource Manager template (ARM template).
However, an ARM template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax. Further, in declarative syntax, you describe your intended deployment without writing the sequence of programming commands to create the deployment. And, if your environment meets the prerequisites and you’re familiar with using ARM templates, select the Deploy to Azure button. Then, the template will open in the Azure portal.
Review the template
A single database has a defined set of compute, memory, IO, and storage resources using one of two purchasing models. However, when you create a single database, you also define a server to manage it and place it within Azure resource group in a specified region.
Deploy the template
Firstly, select Try it from the following PowerShell code block to open Azure Cloud Shell.
Azure PowerShell
$projectName = Read-Host -Prompt “Enter a project name that is used for generating resource 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/master/101-sql-database/azuredeploy.json” -administratorLogin $adminUser -administratorLoginPassword $adminPassword
Read-Host -Prompt “Press [ENTER] to continue …”
Clean up resources
Firstly, keep this resource group, server, and single database if you want to go to the Next steps. However, the next steps show you how to connect and query your database using different methods.
However, to delete the resource group:
Azure PowerShell
$resourceGroupName = Read-Host -Prompt “Enter the Resource Group name”
Remove-AzResourceGroup -Name $resourceGroupName
Reference: Microsoft Documentation