Failed to upgrade SQL Business Critical Standard series(Gen5) to Hyperscale DB

Hi Ken,

It looks like you're trying to scale your Azure SQL Database from the Business Critical tier to the Hyperscale tier, but you're hitting an issue because the database is part of a Sync Group. I've seen this happen before in one of our projects, and the error is pretty straightforward:

'Update to service objective 'SQLDB_HS_Gen5_2' for Sync DBs is not supported for entity 'Finance'.

What this means is that Azure doesn't support scaling databases that are part of a SQL Data Sync group to the Hyperscale tier.

A few things you can consider:

Remove the Sync Group: If moving to Hyperscale is critical, you might have to remove the database from the Sync Group first, scale it, and then set up the sync again. It's a bit of a process, so make sure you've backed everything up and planned accordingly.

Stick with Business Critical: If Sync is a must-have and you can't remove it, you could look into scaling up within the Business Critical tier or other tiers that support Sync Databases. You might get the performance boost you're after without moving to Hyperscale.

Assess whether Hyperscale is necessary: Hyperscale is great for massive scalability, but depending on your requirements, you might be able to achieve what you need by tweaking your current setup (like adding more vCores or adjusting storage).

I've run into this roadblock before, so feel free to reach out if you need help with any of these options.

I hope this helps.

Kind regards,

Revelino