您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

教程:使用 DMS 将 SQL Server 脱机迁移到 Azure SQL 数据库中的单一数据库或共用数据库Tutorial: Migrate SQL Server to a single database or pooled database in Azure SQL Database offline using DMS

可以使用 Azure 数据库迁移服务将数据库从本地 SQL Server 实例迁移到 Azure SQL 数据库You can use the Azure Database Migration Service to migrate the databases from an on-premises SQL Server instance to Azure SQL Database. 在本教程中,将通过使用 Azure 数据库迁移服务,将还原到 SQL Server 2016(或更高版本)本地实例的 Adventureworks2012 数据库迁移到 Azure SQL 数据库中的单一数据库或共用数据库。In this tutorial, you migrate the Adventureworks2012 database restored to an on-premises instance of SQL Server 2016 (or later) to a single database or pooled database in Azure SQL Database by using the Azure Database Migration Service.

本教程介绍如何执行下列操作:In this tutorial, you learn how to:

  • 通过使用数据迁移助手来评估本地数据库。Assess your on-premises database by using the Data Migration Assistant.
  • 通过使用数据迁移助手迁移示例架构。Migrate the sample schema by using the Data Migration Assistant.
  • 创建 Azure 数据库迁移服务的实例。Create an instance of the Azure Database Migration Service.
  • 使用 Azure 数据库迁移服务创建迁移项目。Create a migration project by using the Azure Database Migration Service.
  • 运行迁移。Run the migration.
  • 监视迁移。Monitor the migration.
  • 下载迁移报告。Download a migration report.

提示

使用 Azure 数据库迁移服务将数据库迁移到 Azure 时,可以进行脱机或联机迁移。 When you migrate databases to Azure by using Azure Database Migration Service, you can do an offline or an online migration. 使用脱机迁移时,应用程序停机时间从迁移开始时算起。With an offline migration, application downtime starts when the migration starts. 使用联机迁移时,停机时间仅限在迁移结束时进行转换的那段时间。With an online migration, downtime is limited to the time to cut over at the end of migration. 建议对脱机迁移进行测试,以便确定其停机时间是否可以接受;如果不能接受,请进行联机迁移。We suggest that you test an offline migration to determine whether the downtime is acceptable; if not, do an online migration.

本文介绍如何从 SQL Server 脱机迁移到 Azure SQL 数据库中的单一数据库或共用数据库。This article describes an offline migration from SQL Server to a single database or pooled database in Azure SQL Database. 有关联机迁移,请参阅使用 DMS 将 SQL Server 联机迁移到 Azure SQL 数据库For an online migration, see Migrate SQL Server to Azure SQL Database online using DMS.

先决条件Prerequisites

要完成本教程,需要:To complete this tutorial, you need to:

  • 下载并安装 SQL Server 2016 或更高版本(任意版本)。Download and install SQL Server 2016 or later (any edition).

  • 按照启用或禁用服务器网络协议一文中的说明启用 TCP/IP 协议(在安装 SQL Server Express 时,会默认禁用它)。Enable the TCP/IP protocol, which is disabled by default during SQL Server Express installation, by following the instructions in the article Enable or Disable a Server Network Protocol.

  • 遵循使用 Azure 门户在 Azure SQL 数据库中创建单一数据库一文中的详细信息在 Azure SQL 数据库中创建单一(或入池)数据库。Create a single (or pooled) database in Azure SQL Database, which you do by following the detail in the article Create a single database in Azure SQL Database using the Azure portal.

    备注

    如果你使用 SQL Server Integration Services (SSIS) 并且希望将 SSIS 项目/包的目录数据库 (SSISDB) 从 SQL Server 迁移到 Azure SQL 数据库,则当你在 Azure 数据工厂 (ADF) 中预配 SSIS 时,系统会代表你自动创建和管理目标 SSISDB。If you use SQL Server Integration Services (SSIS) and want to migrate the catalog database for your SSIS projects/packages (SSISDB) from SQL Server to Azure SQL Database, the destination SSISDB will be created and managed automatically on your behalf when you provision SSIS in Azure Data Factory (ADF). 有关如何迁移 SSIS 包的详细信息,请参阅将 SQL Server Integration Services 包迁移到 AzureFor more information about migrating SSIS packages, see the article Migrate SQL Server Integration Services packages to Azure.

  • 下载并安装数据迁移助手 v3.3 或更高版本。Download and install the Data Migration Assistant v3.3 or later.

  • 使用 Azure 资源管理器部署模型创建 Azure 数据库迁移服务的 Azure 虚拟网络 (VNet),它将使用 ExpressRouteVPN 为本地源服务器提供站点到站点连接。Create an Azure Virtual Network (VNet) for the Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN. 有关创建 VNet 的详细信息,请参阅虚拟网络文档,尤其是提供了分步详细信息的快速入门文章。For more information about creating a VNet, see the Virtual Network Documentation, and especially the quickstart articles with step-by-step details.

    备注

    在 VNet 设置期间,如果将 ExpressRoute 与 Microsoft 的网络对等互连一起使用,请将以下服务终结点添加到将在其中预配服务的子网:During VNet setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned:

    • 目标数据库终结点(例如,SQL 终结点、Cosmos DB 终结点等)Target database endpoint (for example, SQL endpoint, Cosmos DB endpoint, and so on)
    • 存储终结点Storage endpoint
    • 服务总线终结点Service bus endpoint

    Azure 数据库迁移服务缺少 Internet 连接,因此必须提供此配置。This configuration is necessary because the Azure Database Migration Service lacks internet connectivity.

  • 请确保 VNet 网络安全组规则未阻止到 Azure 数据库迁移服务以下入站通信端口:443、53、9354、445、12000。Ensure that your VNet Network Security Group rules don't block the following inbound communication ports to Azure Database Migration Service: 443, 53, 9354, 445, 12000. 有关 Azure VNet NSG 流量筛选的更多详细信息,请参阅使用网络安全组筛选网络流量一文。For more detail on Azure VNet NSG traffic filtering, see the article Filter network traffic with network security groups.

  • 配置针对数据库引擎访问的 Windows 防火墙Configure your Windows Firewall for database engine access.

  • 打开 Windows 防火墙,使 Azure 数据库迁移服务能够访问源 SQL Server(默认情况下为 TCP 端口 1433)。Open your Windows firewall to allow the Azure Database Migration Service to access the source SQL Server, which by default is TCP port 1433.

  • 如果使用动态端口运行多个命名 SQL Server 实例,则可能需要启用 SQL Browser 服务并允许通过防火墙访问 UDP 端口 1434,以便 Azure 数据库迁移服务可连接到源服务器上的命名实例。If you're running multiple named SQL Server instances using dynamic ports, you may wish to enable the SQL Browser Service and allow access to UDP port 1434 through your firewalls so that the Azure Database Migration Service can connect to a named instance on your source server.

  • 在源数据库的前面使用了防火墙设备时,可能需要添加防火墙规则以允许 Azure 数据库迁移服务访问要迁移的源数据库。When using a firewall appliance in front of your source database(s), you may need to add firewall rules to allow the Azure Database Migration Service to access the source database(s) for migration.

  • 为 Azure SQL 数据库服务器创建服务器级 IP 防火墙规则,以允许 Azure 数据库迁移服务访问目标数据库。Create a server-level IP firewall rule for the Azure SQL Database server to allow the Azure Database Migration Service access to the target databases. 提供用于 Azure 数据库迁移服务的 VNet 子网范围。Provide the subnet range of the VNet used for the Azure Database Migration Service.

  • 确保用于连接到源 SQL Server 实例的凭据具有 CONTROL SERVER 权限。Ensure that the credentials used to connect to source SQL Server instance have CONTROL SERVER permissions.

  • 确保用于连接到目标 Azure SQL 数据库实例的凭据具有目标 Azure SQL 数据库的 CONTROL DATABASE 权限。Ensure that the credentials used to connect to target Azure SQL Database instance have CONTROL DATABASE permission on the target Azure SQL databases.

访问本地数据库Assess your on-premises database

在将数据从本地 SQL Server 实例迁移到 Azure SQL 数据库中的单一数据库或共用数据库之前,需要对 SQL Server 数据库进行评估,了解任何可能会阻止迁移的阻碍性问题。Before you can migrate data from an on-premises SQL Server instance to a single database or pooled database in Azure SQL Database, you need to assess the SQL Server database for any blocking issues that might prevent migration. 使用数据迁移助手 v3.3 或更高版本,按照执行 SQL Server 迁移评估一文中所述的步骤,完成对本地数据库的评估。Using the Data Migration Assistant v3.3 or later, follow the steps described in the article Performing a SQL Server migration assessment to complete the on-premises database assessment. 所需步骤汇总如下:A summary of the required steps follows:

  1. 在数据迁移助手中,选择“新建 (+)”图标,然后选择“评估”项目类型。In the Data Migration Assistant, select the New (+) icon, and then select the Assessment project type.

  2. 指定项目名称,在“源服务器类型”文本框中,选择“SQL Server”,在“目标服务器类型”文本框中,选择“Azure SQL 数据库”,然后选择“创建”,从而创建项目。Specify a project name, in the Source server type text box, select SQL Server, in the Target server type text box, select Azure SQL Database, and then select Create to create the project.

    评估迁移到 Azure SQL 数据库中的单一数据库或共用数据库的源 SQL Server 数据库时,可以选择以下一种或两种评估报告类型:When you're assessing the source SQL Server database migrating to a single database or pooled database in Azure SQL Database, you can choose one or both of the following assessment report types:

    • 检查数据库兼容性Check database compatibility
    • 检查功能奇偶校验Check feature parity

    默认情况下会选择这两种报告类型。Both report types are selected by default.

  3. 在数据迁移助手的“选项”屏幕上,选择“下一步”。In the Data Migration Assistant, on the Options screen, select Next.

  4. 在“选择源”屏幕上的“连接到服务器”对话框中,向 SQL Server 提供连接详细信息,然后选择“连接”。On the Select sources screen, in the Connect to a server dialog box, provide the connection details to your SQL Server, and then select Connect.

  5. 在“添加源”对话框中,依次选择“AdventureWorks2012”、“添加”和“开始评估”。In the Add sources dialog box, select AdventureWorks2012, select Add, and then select Start Assessment.

    备注

    如果你使用 SSIS,则 DMA 目前不支持对源 SSISDB 进行评估。If you use SSIS, DMA does not currently support the assessment of the source SSISDB. 但是,将 SSIS 项目/包重新部署到由 Azure SQL 数据库托管的目标 SSISDB 时,会对其进行评估/验证。However, SSIS projects/packages will be assessed/validated as they are redeployed to the destination SSISDB hosted by Azure SQL Database. 有关如何迁移 SSIS 包的详细信息,请参阅将 SQL Server Integration Services 包迁移到 AzureFor more information about migrating SSIS packages, see the article Migrate SQL Server Integration Services packages to Azure.

    评估完成后,结果将如下图所示:When the assessment is complete, the results display as shown in the following graphic:

    评估数据迁移

    对于 Azure SQL 数据库中国的单一数据库或共用数据库,评估结果可标识出在部署到单一数据库或共用数据库时会出现的功能奇偶一致性问题和迁移阻塞性问题。For single databases or pooled databases in Azure SQL Database, the assessments identify feature parity issues and migration blocking issues for deploying to a single database or pooled database.

    • SQL Server 功能奇偶校验类别在 Azure 中提供了一套全面的建议、可用的替代方法和缓解步骤,以帮助你在迁移项目中规划工作。The SQL Server feature parity category provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps to help you plan the effort into your migration projects.
    • 兼容性问题类别说明了部分支持或完全不支持的功能,这些功能反映了可能会阻止本地 SQL Server 数据库迁移到 Azure SQL 数据库的兼容性问题。The Compatibility issues category identifies partially supported or unsupported features that reflect compatibility issues that might block migrating on-premises SQL Server database(s) to Azure SQL Database. 此外,还提供了一些建议来帮助你解决这些问题。Recommendations are also provided to help you address those issues.
  6. 通过选择特定的选项来查看迁移阻塞问题和功能奇偶校验问题的评估结果。Review the assessment results for migration blocking issues and feature parity issues by selecting the specific options.

迁移示例架构Migrate the sample schema

如果对评估感到满意,并确信所选数据库适合迁移到 Azure SQL 数据库中的单一数据库或共用数据库,请使用 DMA 将架构迁移到 Azure SQL 数据库。After you're comfortable with the assessment and satisfied that the selected database is a viable candidate for migration to a single database or pooled database in Azure SQL Database, use DMA to migrate the schema to Azure SQL Database.

备注

在数据迁移助手中创建迁移项目之前,请确保已按照先决条件中的说明预配了 Azure SQL 数据库。Before you create a migration project in Data Migration Assistant, be sure that you have already provisioned an Azure SQL database as mentioned in the prerequisites. 出于本教程的目的,假设 Azure SQL 数据库的名称是“AdventureWorksAzure”,但是你可按照自己意愿使用任意名称命名。For purposes of this tutorial, the name of the Azure SQL Database is assumed to be AdventureWorksAzure, but you can provide whatever name you wish.

重要

如果你使用 SSIS,则 DMA 目前不支持迁移源 SSISDB,但你可以将 SSIS 项目/包重新部署到由 Azure SQL 数据库托管的目标 SSISDB。If you use SSIS, DMA does not currently support the migration of source SSISDB, but you can redeploy your SSIS projects/packages to the destination SSISDB hosted by Azure SQL Database. 有关如何迁移 SSIS 包的详细信息,请参阅将 SQL Server Integration Services 包迁移到 AzureFor more information about migrating SSIS packages, see the article Migrate SQL Server Integration Services packages to Azure.

要将 AdventureWorks2012 架构迁移到 Azure SQL 数据库中的单一数据库或共用数据库,请执行以下步骤:To migrate the AdventureWorks2012 schema to a single database or pooled database Azure SQL Database, perform the following steps:

  1. 在数据迁移助手中,选择“新建 (+)”图标,然后在“项目类型”下选择“迁移”。In the Data Migration Assistant, select the New (+) icon, and then under Project type, select Migration.

  2. 指定项目名称,在“源服务器类型”文本框中,选择“SQL Server”,然后在“目标服务器类型”文本框中,选择“Azure SQL 数据库”。Specify a project name, in the Source server type text box, select SQL Server, and then in the Target server type text box, select Azure SQL Database.

  3. 在“迁移范围”下,选择“仅架构”。Under Migration Scope, select Schema only.

    在执行前面的步骤后,数据迁移助手界面应如下图所示:After performing the previous steps, the Data Migration Assistant interface should appear as shown in the following graphic:

    创建数据迁移助手项目

  4. 选择“创建”来创建项目。Select Create to create the project.

  5. 在数据迁移助手中,指定 SQL Server 的源连接详细信息,依次选择“连接”和“AdventureWorks2012”数据库。In the Data Migration Assistant, specify the source connection details for your SQL Server, select Connect, and then select the AdventureWorks2012 database.

    数据迁移助手源连接详细信息

  6. 在“连接到目标服务器”下选择“下一步”,指定 Azure SQL 数据库的目标连接详细信息,选择“连接”,然后选择在 Azure SQL 数据库中已预配的“AdventureWorksAzure”数据库。Select Next, under Connect to target server, specify the target connection details for the Azure SQL database, select Connect, and then select the AdventureWorksAzure database you had pre-provisioned in Azure SQL database.

    数据迁移助手目标连接详细信息

  7. 选择“下一步”,以转到“选择对象”屏幕,可以在其中指定需要部署到 Azure SQL 数据库的“AdventureWorks2012”中的架构对象。Select Next to advance to the Select objects screen, on which you can specify the schema objects in the AdventureWorks2012 database that need to be deployed to Azure SQL Database.

    默认情况下,选择所有对象。By default, all objects are selected.

    生成 SQL 脚本

  8. 选择“生成 SQL 脚本”以创建 SQL 脚本,然后检查脚本是否有任何错误。Select Generate SQL script to create the SQL scripts, and then review the scripts for any errors.

    架构脚本

  9. 选择“部署架构”以将架构部署到 Azure SQL 数据库,然后在部署架构后,检查目标服务器是否存在任何异常情况。Select Deploy schema to deploy the schema to Azure SQL Database, and then after the schema is deployed, check the target server for any anomalies.

    部署架构

注册 Microsoft.DataMigration 资源提供程序Register the Microsoft.DataMigration resource provider

  1. 登录到 Azure 门户,选择“所有服务”,然后选择“订阅”。Sign in to the Azure portal, select All services, and then select Subscriptions.

    显示门户订阅

  2. 选择要在其中创建 Azure 数据库迁移服务实例的订阅,再选择“资源提供程序”。Select the subscription in which you want to create the instance of the Azure Database Migration Service, and then select Resource providers.

    显示资源提供程序

  3. 搜索迁移服务,再选择“Microsoft.DataMigration”右侧的“注册”。Search for migration, and then to the right of Microsoft.DataMigration, select Register.

    注册资源提供程序

创建实例Create an instance

  1. 在 Azure 门户中,选择 + 创建资源,搜索 Azure 数据库迁移服务,然后从下拉列表选择Azure 数据库迁移服务In the Azure portal, select + Create a resource, search for Azure Database Migration Service, and then select Azure Database Migration Service from the drop-down list.

    Azure 市场

  2. 在“Azure 数据库迁移服务”屏幕上,选择“创建”。On the Azure Database Migration Service screen, select Create.

    创建 Azure 数据库迁移服务实例

  3. 在“创建迁移服务”屏幕上,为服务、订阅以及新的或现有资源组指定名称。On the Create Migration Service screen, specify a name for the service, the subscription, and a new or existing resource group.

  4. 选择要在其中创建 Azure 数据库迁移服务实例的位置。Select the location in which you want to create the instance of the Azure Database Migration Service.

  5. 选择现有的 VNet,或新建一个 VNet。Select an existing VNet or create a new one.

    VNet 为 Azure 数据库迁移服务提供了对源 SQL Server 和目标 Azure SQL 数据库实例的访问权限。The VNet provides the Azure Database Migration Service with access to the source SQL Server and the target Azure SQL Database instance.

    若要详细了解如何在 Azure 门户中创建 VNet,请参阅使用 Azure 门户创建虚拟网络一文。For more information about how to create a VNet in the Azure portal, see the article Create a virtual network using the Azure portal.

  6. 选择定价层。Select a pricing tier.

    有关成本和定价层的详细信息,请参阅价格页For more information on costs and pricing tiers, see the pricing page.

    配置 Azure 数据库迁移服务实例设置

  7. 选择“创建”来创建服务。Select Create to create the service.

创建迁移项目Create a migration project

创建服务后,在 Azure 门户中找到并打开它,然后创建一个新的迁移项目。After the service is created, locate it within the Azure portal, open it, and then create a new migration project.

  1. 在 Azure 门户中,选择“所有服务”,搜索 Azure 数据库迁移服务,然后选择“Azure 数据库迁移服务”。In the Azure portal, select All services, search for Azure Database Migration Service, and then select Azure Database Migration Services.

    查找 Azure 数据库迁移服务的所有实例

  2. 在“Azure 数据库迁移服务”屏幕上,搜索你创建的 Azure 数据库迁移服务实例名称,然后选择该实例。On the Azure Database Migration Services screen, search for the name of the Azure Database Migration Service instance that you created, and then select the instance.

    查找 Azure 数据库迁移服务实例

  3. 选择“+ 新建迁移项目”。Select + New Migration Project.

  4. 在“新建迁移项目”屏幕上指定项目名称,在“源服务器类型”文本框中选择“SQL Server”,在“目标服务器类型”文本框中选择“Azure SQL 数据库”,然后在“选择活动类型”中选择“脱机数据迁移”。On the New migration project screen, specify a name for the project, in the Source server type text box, select SQL Server, in the Target server type text box, select Azure SQL Database, and then for Choose type of activity, select Offline data migration.

    创建数据库迁移服务项目

  5. 选择“创建并运行活动”,以便创建项目并运行迁移活动。Select Create and run activity to create the project and run the migration activity.

指定源详细信息Specify source details

  1. 在“迁移源详细信息”屏幕上,指定源 SQL Server 实例的连接详细信息。On the Migration source detail screen, specify the connection details for the source SQL Server instance.

    请确保为源 SQL Server 实例名称使用完全限定的域名 (FQDN)。Make sure to use a Fully Qualified Domain Name (FQDN) for the source SQL Server instance name. 即使不能使用 DNS 名称解析,也可使用 IP 地址。You can also use the IP Address for situations in which DNS name resolution isn't possible.

  2. 如果尚未在源服务器上安装受信任的证书,请选中“信任服务器证书”复选框。If you have not installed a trusted certificate on your source server, select the Trust server certificate check box.

    如果没有安装受信任的证书,SQL Server 会在实例启动时生成自签名证书。When a trusted certificate is not installed, SQL Server generates a self-signed certificate when the instance is started. 此证书用于加密客户端连接的凭据。This certificate is used to encrypt the credentials for client connections.

    注意

    使用自签名证书加密的 SSL 连接不提供可靠的安全性。SSL connections that are encrypted using a self-signed certificate do not provide strong security. 它们易遭受中间人攻击。They are susceptible to man-in-the-middle attacks. 不得在生产环境中或在连接到 Internet 的服务器上依赖使用自签名证书的 SSL。You should not rely on SSL using self-signed certificates in a production environment or on servers that are connected to the internet.

    源详细信息

    重要

    如果你使用 SSIS,则 DMS 目前不支持迁移源 SSISDB,但你可以将 SSIS 项目/包重新部署到由 Azure SQL 数据库托管的目标 SSISDB。If you use SSIS, DMS does not currently support the migration of source SSISDB, but you can redeploy your SSIS projects/packages to the destination SSISDB hosted by Azure SQL Database. 有关如何迁移 SSIS 包的详细信息,请参阅将 SQL Server Integration Services 包迁移到 AzureFor more information about migrating SSIS packages, see the article Migrate SQL Server Integration Services packages to Azure.

指定目标详细信息Specify target details

  1. 选择“保存”,然后在“迁移目标详细信息”屏幕中,指定目标 Azure SQL 数据库服务器的连接详细信息,这是使用数据迁移助手向其部署 AdventureWorks2012 架构的预配 Azure SQL 数据库。Select Save, and then on the Migration target details screen, specify the connection details for the target Azure SQL Database Server, which is the pre-provisioned Azure SQL Database to which the AdventureWorks2012 schema was deployed by using the Data Migration Assistant.

    选择目标

  2. 选择“保存”,然后在“映射到目标数据库”屏幕上,映射源和目标数据库以进行迁移。Select Save, and then on the Map to target databases screen, map the source and the target database for migration.

    如果目标数据库包含的数据库名称与源数据库的相同,则 Azure 数据库迁移服务会默认选择目标数据库。If the target database contains the same database name as the source database, the Azure Database Migration Service selects the target database by default.

    映射到目标数据库

  3. 在“选择表”屏幕上选择“保存”,展开表列表,如何查看受影响字段的列表。Select Save, on the Select tables screen, expand the table listing, and then review the list of affected fields.

    请注意,Azure 数据库迁移服务会自动选择目标 Azure SQL 数据库实例上的所有空源表。Note that the Azure Database Migration Service auto selects all the empty source tables that exist on the target Azure SQL Database instance. 若要重新迁移已含数据的表,需要在此边栏选项卡上明确选择表。If you want to remigrate tables that already include data, you need to explicitly select the tables on this blade.

    选择表

  4. 在“迁移摘要”屏幕上,选择“保存”,在“活动名称”文本框中,指定迁移活动的名称。Select Save, on the Migration summary screen, in the Activity name text box, specify a name for the migration activity.

  5. 展开“验证选项”部分以显示“选择验证选项”屏幕,然后指定是否对已迁移数据库执行“架构比较”、“数据一致性”和“查询正确性”验证。Expand the Validation option section to display the Choose validation option screen, and then specify whether to validate the migrated databases for Schema comparison, Data consistency, and Query correctness.

    选择“验证”选项

  6. 选择“保存”,查看摘要以确保源和目标详细信息与你先前指定的内容匹配。Select Save, review the summary to ensure that the source and target details match what you previously specified.

    迁移摘要

运行迁移Run the migration

  • 选择“运行迁移”。Select Run migration.

    迁移活动窗口随即出现,活动的“状态”为“挂起”。The migration activity window appears, and the Status of the activity is Pending.

    活动状态

监视迁移Monitor the migration

  1. 在迁移活动屏幕上,选择“刷新”来更新显示,直到迁移的“状态”显示为“已完成”。On the migration activity screen, select Refresh to update the display until the Status of the migration shows as Completed.

    活动状态已完成

  2. 迁移完成后,选择“下载报告”可获取报告,其上列出了与迁移过程相关的详细信息。After the migration completes, select Download report to get a report listing the details associated with the migration process.

  3. 验证目标 Azure SQL 数据库服务器上的一个或多个目标数据库。Verify the target database(s) on the target Azure SQL Database server.

其他资源Additional resources