Azure SQL Database Migrating across Tiers

A quick post today about moving across database tiers. As you can see below I have a General Purpose Serverless Gen 5 1 vCore database (currently paused). Can I move this back to a DTU based model?

gen5

Let’s test this. Within the configure page I select DTUs.

dtumodel

I try a downgrade.

scaledowns

As you can see, it is flexible, you are not stuck moving between tiers. The only route that is not possible is if you have moved to Hyperscale and decide that you want to move back to a different one.

You can’t.

hyperscaled'

This is worth remembering.

2 thoughts on “Azure SQL Database Migrating across Tiers

    • Hi john, good question. I dont know the “official” answer but I might find out. Im guessing its the very different underlying architecture they use for it. Only way they say is via data movement technologies (Bulk Copy, Azure Data Factory, Azure Databricks, SSIS, etc.) Bacpac export/import from Azure portal… ouch.

      Like

Leave a Reply to johnsoftwareengineer Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s