How to deploy Azure SQL Database with ARM Template

Saturday , 21, January 2023 dfirst Microsoft Azure

ARM (Azure Resource Manager) template is a declarative solution template for Azure Resource Manager (ARM) API. Users can deploy Azure resources with PowerShell command and ARM (Azure Resource Manager) template files. In this demo, Azure SQL Database is deployed with ARM template files and following PowerShell commands.

# Az module installation

Install-Module -Name Az -Scope CurrentUser -Repository PSGallery -Force

 

# Sign in to Azure tenant

Connect-AzAccount

 

# Get information about Azure subscription

get-AzSubscription

 

# Specify Azure subscription with parameters of -SubscriptionId and -TenantId

Get-AzSubscription -SubscriptionId "<subscription-id>" -TenantId "<tenant-id>" | Set-AzContext

 

# Deploy Azure SQL Database with ARM template files

New-AzResourceGroupDeployment `

-Name "<deployment name>" `

-ResourceGroupName "<resource group name>" `

-TemplateFile "<path>\template.json" `

-TemplateParameterFile "<path>\parameters.json"

 

# Get ResourceId to remove Azure SQL Database

Get-AzResource -ResourceGroupName "<resource group name>" -Name "<resource name>"

 

# Remove Azure SQL Database

Remove-AzResource -ResourceId "<resource id>"