azure - 如何在 Azure SQL 数据库中从 DTU 迁移到 vCore

Question

目前，我们的 Azure 资源有 3 个(开发、质量保证和生产)阶段。这三个都使用 SQL 数据库“标准 S6:400 DTU”。由于 SQL 数据库的开发和 QA，我们每月的成本超过 700 欧元。我计划从 DTU 迁移到 vCore 无服务器。以下是我的疑问，

1. 只需进入门户 -> 计算和存储 -> 并从 DTU 更改为 vCore Serverless 是正确的流程吗？
2. 在进行此操作之前我还需要采取任何其他措施吗？
3. 我现有的 Azure SQL 数据库会受到此操作的影响吗？
4. 如果情况不符合我的要求，我可以按照同样的方式返回 DTU 模式。

提前致谢。

Answer 1

您可以查看此 MS 文档以了解详细信息:Migrate Azure SQL Database from the DTU-based model to the vCore-based model

1. 刚刚进入门户 -> 计算和存储 -> 并从DTU 到 vCore Serverless 是正确的过程吗？

Yes! just change to required option from dropdown and click on Apply.Migrating a database from the DTU-based purchasing model to thevCore-based purchasing model is similar to scaling between serviceobjectives in the Basic, Standard, and Premium service tiers, withsimilar duration and a minimal downtime at the end of the migrationprocess.

在进行此操作之前我还需要采取任何其他措施吗？

• Some hardware generations may not be available in every region. Check availability under Hardware generations for SQLDatabase.
• In the vCore model, the supported maximum database size may differ depending on hardware generation. For large databases, check supportedmaximum sizes in the vCore model for singledatabasesand elasticpools.
• If you have geo-replicated databases, during migration, you don't haveto stop geo-replication, but you must upgrade the secondary databasefirst, and then upgrade the primary. When downgrading, reverse theorder Also go through the doc once.

我现有的 Azure SQL 数据库是否会受到此影响操作？

You can copy any database with a DTU-based compute size to a databasewith a vCore-based compute size without restrictions or specialsequencing as long as the target compute size supports the maximumdatabase size of the source database. Database copy creates atransactionally consistent snapshot of the data as of a point in timeafter the copy operation starts. It doesn't synchronize data betweenthe source and the target after that point in time.

如果事情不符合我的要求，我可以以同样的方式来吗返回DTU模式。

A database migrated to the vCore-based purchasing model can bemigrated back to the DTU-based purchasing model at any time in thesame fashion, with the exception of databases migrated to theHyperscale service tier.