Hyperscale to general purpose

Question

We have a azure hyperscale sql db. We want to restore it to general purpose.

Is anybody know to restore azure hyperscale sql database to general purpose database ?

Thanks in advance,

Answer 1

No. The storage format for Hyperscale databases is different from any released version of SQL Server, and you don’t control backups or have access to them. To take your data out of a Hyperscale database, you can extract data using any data movement technologies, i.e. Azure Data Factory, Azure Databricks, SSIS, etc. Source: Microsoft Docs here.

You can also try to create a bacpac and export it to an Azure storage account, and from there import it to the other vCore tiers as explained here.

Answer 2

Very recent update to this answer, you can actually do this now, but only within 45 days of going to hyperscale for some reason, so you're likely screwed: https://docs.microsoft.com/en-us/azure/azure-sql/database/manage-hyperscale-database?tabs=azure-portal

Answer 3

Can't you use ALTER DATABASE? Something like the following:

ALTER DATABASE [db1] MODIFY (EDITION = 'GeneralPurpose');

Note, that you may need to specify the MAXSIZE, too in order to match the valid for the particular edition. For example:

ALTER DATABASE [db1] MODIFY (EDITION = 'Standard', MAXSIZE = 250 GB, SERVICE_OBJECTIVE = 'S0');