Wednesday, April 13, 2022

How to reverse migrate your Azure SQL Database from Hyperscale tier to General Purpose tier

We are happy to announce preview release of the ability to reverse migrate an Azure SQL Database from Hyperscale tier to General Purpose tier. Previously, migration into the Hyperscale tier was a one-way migration with no easy way to move back to any non-Hyperscale tier. Reverse Migration to the General Purpose service tier now allows customers who have recently migrated an existing Azure SQL DB database to the Hyperscale service tier to move back, should Hyperscale not meet their needs. This provides additional mobility for their SQL Database data. Once in the General Purpose tier, they have the flexibility to remain on that tier or move their database to other SQL Database tiers including coming back to Hyperscale tier.  

 

The main purpose of this reverse migration feature is to provide customers with an assurance that they can migrate their databases out of the Hyperscale tier if needed, thus removing a point of friction that customers might have had in migrating to the Hyperscale tier. While reverse migration is initiated by a service tier change, it's essentially a size-of-data move between different architectures. Reverse migration can be initiated through Azure Portal, T-SQL, Azure CLI or PowerShell. 

 

Portal

The following diagram illustrates how to use Azure portal to reverse migrate a Hyperscale database to General Purpose tier.

 

SriniAcharya_1-1649451446075.png

T-SQL 

The following T-SQL command can be used to reverse migrate a Hyperscale database to General Purpose tier. 

Below is an example T-SQL command for reverse migrating a Hyperscale database to General Purpose tier 

ALTERDATABASE mydb   

    MODIFY (SERVICE_OBJECTIVE = 'GP_Gen5_4', MAXSIZE = 1024 GB) 

 

CLI

The following CLI command can be used to reverse migrate a Hyperscale database to General Purpose tier.

Below is an example CLI command for reverse migrating a Hyperscale database to General Purpose tier

az sql db update -g mygroup -s myserver -n mydb -e GeneralPurpose -service-objective GP_Gen5_4

 

PowerShell

The following PowerShell command can be used to reverse migrate a Hyperscale database to General Purpose tier

 Below is an example PowerShell command for reverse migrating a Hyperscale database to General Purpose tier

Set-AzSqlDatabase -ResourceGroupName  ”mygroup” -ServerName ”myserver”  -DatabaseName ”mydb” -Edition "GeneralPurpose"  -RequestedServiceObjectiveName  "GP_Gen5_4" 

 

For more information on this reverse migration feature please see Azure SQL documentation 

 

Posted at https://sl.advdat.com/3M0N5cphttps://sl.advdat.com/3M0N5cp