Total Page Preview: 000000004216
How to Create Azure SQL Database using Powershell
In this article I am going to explain how to create Azure SQL Database using powershell
Create Azure SQL Database using powershell command with ARM Scripts:
#-------- TenantId -------------#
Get TenantId from the Azure Portal:
$tenantid = 'd29b7a9b-6edb-4720-99a8-3c5c6c3eeeb0'
#----------Your UserId and Password--------------------#
$username = 'xxxxxxxxx@live.com'
$password = 'xxxxxxxxxxx' | ConvertTo-SecureString -asPlainText -Force
$cred = New-Object System.Management.Automation.PSCredential($username, $password)
Login-AzureRmAccount -TenantId $tenantid -Credential $cred
#------------------------If you have multiple subscriptionId in single account-----------#
$subscriptionId = (Get-AzureRmSubscription | Out-GridView -Title "Select an Azure Subscription …" -PassThru).SubscriptionId
#------------------------for single subscriptionId -----------#
$subscriptionId = (Get-AzureRmSubscription).SubscriptionId
#------------ Please enter already existing Resource group and Azure SQL Server Name -------------#
$rgroup = Read-Host -Prompt 'Enter Resource Group name'
$serverName = Read-Host -Prompt 'Please Enter Azure SQL Server Name'
#------------------------- Creating Azure SQL Database-------------------#
$databaseName = Read-Host -Prompt 'Please Enter Azure SQL Database Name'
$databaseEdition = Read-Host -Prompt 'Please Enter Edition' #------ Basic, Standard, Premium ---------#
$databaseServiceLevel = Read-Host -Prompt 'Please Enter Service Level'
$currentDatabase = New-AzureRmSqlDatabase -ResourceGroupName $rgroup -ServerName $serverName -DatabaseName `
$databaseName -Edition $databaseEdition -RequestedServiceObjectiveName $databaseServiceLevel
Write-Host "Database"$databaseName" Edition "$databaseEdition $databaseServiceLevel" Created Succcessfully !"
Create Azure SQL Database using powershell command with ARM:
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com