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

将 SQL Server Integration Services 包迁移到 Azure SQL 托管实例Migrate SQL Server Integration Services packages to an Azure SQL Managed Instance

如果使用 SQL Server Integration Services (SSIS) 并想将 SSIS 项目/包从 SQL Server 托管的源 SSISDB 迁移到 Azure SQL 托管实例托管的目标 SSISDB,可以使用 Azure 数据库迁移服务。If you use SQL Server Integration Services (SSIS) and want to migrate your SSIS projects/packages from the source SSISDB hosted by SQL Server to the destination SSISDB hosted by an Azure SQL Managed Instance, you can use Azure Database Migration Service.

如果使用的 SSIS 版本早于 2012 年版,或者使用非 SSISDB 包存储类型,则在迁移 SSIS 项目/包之前,需要使用 Integration Services 项目转换向导来转换它们,该向导也可从 SSMS 中启动。If the version of SSIS you use is earlier than 2012 or you use non-SSISDB package store types, before migrating your SSIS projects/packages, you need to convert them by using the Integration Services Project Conversion Wizard, which can also be launched from SSMS. 有关详细信息,请参阅文章将项目转换为项目部署模型For more information, see the article Converting projects to the project deployment model.

备注

Azure 数据库迁移服务 (DMS) 目前不支持将 Azure SQL 数据库用作迁移目标。Azure Database Migration Service (DMS) currently does not support Azure SQL Database as a target migration destination. 若要将 SSIS 项目/包重新部署到 Azure SQL 数据库,请参阅将 SQL Server Integration Services 包重新部署到 Azure SQL 数据库To redeploy SSIS projects/packages to Azure SQL Database, see the article Redeploy SQL Server Integration Services packages to Azure SQL Database.

在本文中,学习如何:In this article, you learn how to:

  • 评估源 SSIS 项目/包。Assess source SSIS projects/packages.
  • 将 SSIS 项目/包迁移到 Azure。Migrate SSIS projects/packages to Azure.

先决条件Prerequisites

若要完成这些步骤,需满足以下条件:To complete these steps, you need:

  • 若要使用 Azure 资源管理器部署模型创建 Azure 数据库迁移服务的 Microsoft Azure 虚拟网络,可以使用 ExpressRouteVPN为本地源服务器提供站点到站点连接。To create a Microsoft Azure Virtual Network 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. 有关详细信息,请参阅使用 Azure 数据库迁移服务迁移 SQL 托管实例的网络拓扑一文。For more information, see the article Network topologies for SQL Managed Instance migrations using Azure Database Migration Service. 有关创建虚拟网络的详细信息,请参阅虚拟网络文档,尤其是提供了分步详细信息的快速入门文章。For more information about creating a virtual network, see the Virtual Network Documentation, and especially the quickstart articles with step-by-step details.
  • 若要确保虚拟网络安全组规则不会阻止 ServiceTag 的出站端口443、存储和 AzureMonitor。To ensure that your virtual network Network Security Group rules don't block the outbound port 443 of ServiceTag for ServiceBus, Storage and AzureMonitor. 有关虚拟网络 NSG 流量筛选的更多详细信息,请参阅使用网络安全组筛选网络流量一文。For more detail on virtual network NSG traffic filtering, see the article Filter network traffic with network security groups.
  • 配置针对源数据库引擎访问的 Windows 防火墙To configure your Windows Firewall for source database engine access.
  • 打开 Windows 防火墙,使 Azure 数据库迁移服务能够访问源 SQL Server(默认情况下为 TCP 端口 1433)。To 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 数据库迁移服务访问要迁移的源数据库,并通过 SMB 端口 445 访问文件。If you're using a firewall appliance in front of your source databases, you may need to add firewall rules to allow the Azure Database Migration Service to access the source database(s) for migration, as well as files via SMB port 445.
  • 用于托管 SSISDB 的 SQL 托管实例。A SQL Managed Instance to host SSISDB. 如需创建一个,请按创建 Azure SQL 托管实例一文中的详细说明操作。If you need to create one, follow the detail in the article Create a Azure SQL Managed Instance.
  • 确保用于连接源 SQL Server 和目标托管实例的登录名是 sysadmin 服务器角色的成员。To ensure that the logins used to connect the source SQL Server and target managed instance are members of the sysadmin server role.
  • 验证是否在包含 Azure-SSIS Integration Runtime (IR) 的 Azure 数据工厂 (ADF) 中预配了 SSIS,并且其目标 SSISDB 由 SQL 托管实例托管(如在 Azure 数据工厂中创建 Azure-SSIS Integration Runtime 一文所述)。To verify that SSIS is provisioned in Azure Data Factory (ADF) containing Azure-SSIS Integration Runtime (IR) with the destination SSISDB hosted by a SQL Managed Instance (as described in the article Create the Azure-SSIS integration runtime in Azure Data Factory).

评估源 SSIS 项目/包Assess source SSIS projects/packages

虽然尚未将源 SSISDB 的评估集成到数据库迁移助手 (DMA) 中,但在将 SSIS 项目/包重新部署到 Azure SQL 托管实例上托管的目标 SSISDB 时,将对其进行评估/验证。While assessment of source SSISDB isn't yet integrated into the Database Migration Assistant (DMA), your SSIS projects/packages will be assessed/validated as they're redeployed to the destination SSISDB hosted on a Azure SQL Managed Instance.

注册 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 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.

    注册资源提供程序

创建 Azure 数据库迁移服务实例Create an Azure Database Migration Service 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. 选择要在其中创建 DMS 实例的位置。Select the location in which you want to create the instance of DMS.

  5. 选择现有的虚拟网络或创建一个虚拟网络。Select an existing virtual network or create one.

    虚拟网络为 Azure 数据库迁移服务提供源 SQL Server 和目标 Azure SQL 托管实例的访问权限。The virtual network provides Azure Database Migration Service with access to the source SQL Server and target Azure SQL Managed Instance.

    有关如何在 Azure 门户中创建虚拟网络的详细信息,请参阅使用 Azure 门户创建虚拟网络一文。For more information on how to create a virtual network in Azure portal, see the article Create a virtual network using the Azure portal.

    有关更多详细信息,请参阅使用 Azure 数据库迁移服务迁移 Azure SQL 托管实例的网络拓扑一文。For additional detail, see the article Network topologies for Azure SQL Managed Instance migrations using the Azure Database Migration Service.

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

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

    创建 DMS 服务

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

创建迁移项目Create a migration project

创建服务实例后,在 Azure 门户中找到并打开它,然后创建一个新的迁移项目。After an instance of 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 数据库迁移服务”屏幕上,搜索创建的实例名称,然后选择该实例。On the Azure Database Migration Service screen, search for the name of the instance that you created, and then select the instance.

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

  4. 在“新建迁移项目”屏幕上指定项目名称,在“源服务器类型”文本框中选择“SQL Server”,在“目标服务器类型”文本框中选择“Azure SQL 托管实例”,然后在“选择活动类型”中选择“SSIS 包迁移”。 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 Managed Instance, and then for Choose type of activity, select SSIS package migration.

    创建 DMS 项目

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

指定源详细信息Specify source details

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

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

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

    注意

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

    源详细信息

  3. 选择“保存” 。Select Save.

指定目标详细信息Specify target details

  1. 在“迁移目标详细信息”屏幕上,指定目标的连接详细信息。On the Migration target details screen, specify the connection details for the target.

    目标详细信息

  2. 选择“保存” 。Select Save.

查看迁移摘要Review the migration summary

  1. 在“迁移摘要”屏幕的“活动名称”文本框中指定迁移活动的名称。 On the Migration summary screen, in the Activity name text box, specify a name for the migration activity.

  2. 对于 SSIS 项目和环境覆盖选项,请指定是覆盖还是忽略现有的 SSIS 项目和环境。For the SSIS project(s) and environment(s) overwrite option, specify whether to overwrite or ignore existing SSIS projects and environments.

    迁移项目摘要

  3. 查看并验证与迁移项目关联的详细信息。Review and verify the details associated with the migration project.

运行迁移Run the migration

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

后续步骤Next steps