对在 Azure 区域之间移动 Azure SQL 资源的支持Support for moving Azure SQL resources between Azure regions

本文总结了对使用 Azure 资源转移器在 Azure 区域之间移动 Azure SQL 资源的支持和先决条件。This article summarizes support and prerequisites for moving Azure SQL resources between Azure regions with Azure Resource Mover.

要求Requirements

下表汇总了各项要求。Requirements are summarized in the following table.

功能Feature 支持/不支持Supported/Not supported 详细信息Details
Azure SQL 数据库超大规模Azure SQL Database Hyperscale 不支持Not supported 无法使用资源转移器移动 Azure SQL“超大规模”服务层级中的数据库。Can't move databases in the Azure SQL Hyperscale service tier with Resource Mover.
区域冗余Zone redundancy 支持Supported 支持的移动选项:Supported move options:

- 在支持区域冗余的区域之间移动。- Between regions that support zone redundancy.

- 在不支持区域冗余的区域之间移动。- Between regions that don't support zone redundancy.

- 从支持区域冗余的区域移动到不支持区域冗余的区域。- Between a region that supports zone redundancy to a region that doesn't support zone redundancy.

- 从不支持区域冗余的区域移动到支持区域冗余的区域。- Between a region that doesn't support zone redundancy to a region that does support zone redundancy.
数据同步Data sync 中心/同步数据库:不支持Hub/sync database: Not supported

同步成员:。Sync member: Supported.
如果移动了同步成员,你需要将 SQL 数据同步设置到新的目标数据库。If a sync member is moved, you need to set up data sync to the new target database.
现有的异地复制Existing geo-replication 支持Supported 现有的异地副本会重新映射到目标区域中的新主副本。Existing geo replicas are remapped to the new primary in the target region.

在移动之后,必须初始化种子设定。Seeding must be initialized after the move. 了解更多信息Learn more
使用“创建自己的密钥”(BYOK) 进行透明数据加密 (TDE)Transparent Data Encryption (TDE) with Bring Your Own Key (BYOK) 支持Supported 详细了解如何在区域之间移动密钥保管库。Learn more about moving key vaults across regions.
使用服务托管密钥进行 TDETDE with service-managed key Supported. 详细了解如何在区域之间移动密钥保管库。Learn more about moving key vaults across regions.
动态数据掩码规则Dynamic data masking rules Supported. 在移动过程中,规则会自动复制到目标区域。Rules are automatically copied over to the target region as part of the move. 了解详细信息Learn more.
高级数据安全性Advanced data security 不支持。Not supported. 解决方法:在目标区域中进行 SQL Server 级别的设置。Workaround: Set up at the SQL Server level in the target region. 了解详细信息Learn more.
防火墙规则Firewall rules 不支持。Not supported. 解决方法:在目标区域中为 SQL Server 设置防火墙规则。Workaround: Set up firewall rules for SQL Server in the target region. 数据库级防火墙规则会从源服务器复制到目标服务器。Database-level firewall rules are copied from the source server to the target server. 了解详细信息Learn more.
审核策略Auditing policies 不支持。Not supported. 在移动之后,策略将会重置为默认值。Policies will reset to default after the move. 了解如何重置。Learn how to reset.
备份保留期Backup retention Supported. 源数据库的备份保留策略将转移到目标数据库。Backup retention policies for the source database are carried over to the target database. 了解如何在移动之后修改设置。Learn how to modify settings after the move.
自动优化Auto tuning 不支持。Not supported. 解决方法:在移动之后设置自动优化设置。Workaround: Set auto tuning settings after the move. 了解详细信息Learn more.
数据库警报Database alerts 不支持。Not supported. 解决方法:在移动之后设置警报。Workaround: Set alerts after the move. 了解详细信息Learn more.
Azure SQL Server 延伸数据库Azure SQL Server stretch database 不支持Not Supported 无法使用资源转移器移动 SQL Server 延伸数据库。Can't move SQL server stretch databases with Resource Mover.
Azure Synapse AnalyticsAzure Synapse Analytics 不支持Not Supported 无法使用资源转移器移动 Azure Synapse Analytics。Can’t move Azure Synapse Analytics with Resource Mover.

后续步骤Next steps

尝试使用资源转移器将 Azure SQL 资源移动到另一区域。Try Azure SQL resources to another region with Resource Mover.