Azure SQL Database automate scale between DTU model to vCore model

Question

Automating scaling within the DTU purchasing model is relatively straightforward (i.e. using power shell) however I'm struggling to find a way to scale between purchasing models. A typical scenario would be automating a scale from S2 tier to BC_Gen5_6 vcore model.

Can anyone advise any available scripts/options that allow this capability (with parameters covering model, storage, hybrid licensing, read replica...) or is there a valid reason why this is not possible?

Thanks

Answer 1

Hi @jase jackson USA , welcome to Microsoft Q&A forum.

Please refer to below PowerShell script to migrate an existing DTU based model to vCores:

$database = Set-AzSqlDatabase -ResourceGroupName $resourceGroupName `  
    -ServerName $servername `  
    -DatabaseName $databasename `  
    -Edition "GeneralPurpose" `  
    -RequestedServiceObjectiveName "GP_Gen4_2" `  
    -MaxSizeBytes 1099511627776 `  
    -HighAvailabilityReplicaCount 2 `  
    -LicenseType BasePrice  

Values for different parameters are as below:

Edition:
None
Basic
Standard
Premium
DataWarehouse
Free
Stretch
GeneralPurpose
Hyperscale
BusinessCritical

RequestedServiceObjectiveName:
It changes with respect to edition we choose. Please refer to below link for more details based on tier we choose:
https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases

-MaxSizeBytes: This changes the storage size of the database

For more details related to PowerShell command you can refer to below link that has complete details about each and every parameter on top of what is mentioned in above script:

https://learn.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabase?view=azps-5.4.0

Please let me know if this helps or else we can discuss further on the same.

----------

If answer helps, please select 'Accept Answer' as this could help other community members having similar queries.