Is there any downtime moving SQL Database from General Purpose to Hyperscale?

Question

Hi All,

We are planning to move SQL Database from General Purpose to Hyperscale. We have 3TB Storage and 12 vCores.

Would like to know if there is any downtime? to plan a maintenance window with the client or it would be as easy as it is to add more storage in the General Purpose?

Thanks for your time,

Answer 1

You will only experience a short period of downtime, generally a few minutes, during the final cutover to the Hyperscale service tier. So please plan for a maintenance window. Plan for a few minutes more if possible to perform some data validations as part of any good migration plan.

Answer 2

Hi @Oscar Flores Thank you for posting your query o Microsoft Q&A and for using Azure Services.

In my understanding you are asking if there is any downtime moving from General Purpose to Hyperscale

You can migrate databases in Azure SQL Database to Hyperscale using the Azure portal, the Azure CLI, PowerShell, or Transact-SQL.

The time required to move an existing database to Hyperscale consists of the time to copy data and the time to replay the changes made in the source database while copying data. The data copy time is proportional to data size. We recommend migrating to Hyperscale during a lower write activity period so that the time to replay accumulated changes to replay will be shorter.

You will only experience a short period of downtime, generally a few minutes, during the final cutover to the Hyperscale service tier.

Please also see the prerequisites before migrating in the following Article.

Regards,
Oury