Total Page Preview:   000000000820

How to upgrade azure SQL Database size using powershell command line

In this article I am going to explain how to upgrade azure SQL Database size using powershell

upgrade azure SQL Database size using powershell command with ARM Scripts:

#-------- TenantId -------------#

Get TenantId from the Azure Portal: 
Get TenantId In Azure
 
$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' 
 
#------------------------------- Upgrade Database size ---------------------------#
$databaseNameRead-Host -Prompt 'Please Enter Azure SQL Database Name'    
 #------ Basic, Standard, Premium ---------#
$databaseEditionRead-Host -Prompt 'Please Enter current database Edition'  
$databaseServiceLevelRead-Host -Prompt 'Please Enter Service Level'
  #------ Basic, Standard, Premium ---------#
$databaseUpgradeEditionRead-Host -Prompt 'Enter Edition to Upgrade size'  
$databaseUpgradeServiceLevelRead-Host -Prompt 'Enter Upgrade Service Level'
 
 
$currentDatabase=Set-AzureRmSqlDatabase -ResourceGroupName $rgroup -ServerName $serverName`
 -DatabaseName $databaseName -Edition $databaseUpgradeEdition -RequestedServiceObjectiveName $databaseUpgradeServiceLevel
 
Write-Host "Upgrade Database"$databaseName"
 Edition "$databaseEdition $databaseServiceLevel "to" $databaseUpgradeEdition $databaseUpgradeServiceLevel" Succcessfully !"
 
 
upgrade azure SQL Database size using powershell command with ARM:
Upgrade Azure SQL Edition Using Powershell
 
By Brijesh Kumar
Thanks 

 

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



Comments


                           
                           

                           

                           

Facebook User: