CODEWITHSUNDEEP
sql-serverazureazure-sql-databasedatabase-administration
Surya
Surya

Reputation: 27

Hyperscale to general purpose

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,

Upvotes: 1

Views: 1631

Answers (3)

MikeLikesDataStuff
MikeLikesDataStuff

Reputation: 1

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://learn.microsoft.com/en-us/azure/azure-sql/database/manage-hyperscale-database?tabs=azure-portal

Upvotes: 0

Alberto Morillo
Alberto Morillo

Reputation: 15648

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.

Upvotes: 2

gotqn
gotqn

Reputation: 43636

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');

Upvotes: -1

Related Questions