使用 Azure 数据库迁移服务将 SSIS 包重新部署到 Azure SQL 数据库Redeploy SSIS packages to Azure SQL Database with Azure Database Migration Service

如果使用 SQL Server Integration Services (SSIS) 并想将 SSIS 项目/包从 SQL Sever 托管的源 SSISDB 迁移到 Azure SQL 数据库托管的目标 SSISDB,可以使用 Integration Services 部署向导来重新部署它们。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 Azure SQL Database, you can redeploy them using the Integration Services Deployment Wizard. 可以从 SQL Server Management Studio (SSMS) 中启动向导。You can launch the wizard from within SQL Server Management Studio (SSMS).

如果使用的 SSIS 版本早于 2012 年版,在将 SSIS 项目/包重新部署到项目部署模型中时,首先需要使用 Integration Services 项目转换向导来转换它们,该向导也可从 SSMS 中启动。If the version of SSIS you use is earlier than 2012, before redeploying your SSIS projects/packages into the project deployment model, you first 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) 目前不支持将源 SSISDB 迁移到 Azure SQL 数据库,但你可以使用以下过程重新部署 SSIS 项目/包。The Azure Database Migration Service (DMS) currently does not support the migration of a source SSISDB to Azure SQL Database, but you can redeploy your SSIS projects/packages using the following process.

在本文中,学习如何: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:

  • SSMS 17.2 版本或更高版本。SSMS version 17.2 or later.
  • 用于托管 SSISDB 的目标数据库服务器的实例。An instance of your target database server to host SSISDB. 如果还没有数据库服务器,请通过导航到 SQL Server(仅限逻辑服务器)表单,使用 Azure 门户创建一个 Azure SQL Database 服务器(不带数据库)。If you don’t already have one, create an Azure SQL Database server (without a database) using the Azure portal by navigating to the SQL Server (logical server only) form.
  • SSIS 必须在包含 Azure-SSIS Integration Runtime (IR) 的 Azure 数据工厂 (ADF) 中进行预配,并且目标 SSISDB 由 SQL 数据库托管(如在 Azure 数据工厂中预配 Azure-SSIS Integration Runtime 一文所述)。SSIS must be provisioned in Azure Data Factory (ADF) containing Azure-SSIS Integration Runtime (IR) with the destination SSISDB hosted by SQL Database (as described in the article Provision the Azure-SSIS Integration Runtime in Azure Data Factory).

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

虽然尚未将源 SSISDB 的评估集成到数据库迁移助手 (DMA) 或 Azure 数据库迁移服务 (DMS) 中,但在将 SSIS 项目/包重新部署到 Azure SQL 数据库托管的目标 SSISDB 时,将对其进行评估/验证。While assessment of source SSISDB is not yet integrated into the Database Migration Assistant (DMA) or the Azure Database Migration Service (DMS), your SSIS projects/packages will be assessed/validated as they are redeployed to the destination SSISDB hosted by Azure SQL Database.

迁移 SSIS 项目/包Migrate SSIS projects/packages

若要将 SSIS 项目/包迁移到 Azure SQL 数据库,请执行以下步骤。To migrate SSIS projects/packages to Azure SQL Database, perform the following steps.

  1. 打开 SSMS,并选择“选项”以显示“连接到服务器”对话框 。Open SSMS, and then select Options to display the Connect to Server dialog box.

  2. 在“登录”选项卡上,指定连接到托管目标 SSISDB 的服务器所需的信息。On the Login tab, specify the information necessary to connect to the server that will host the destination SSISDB.

    SSIS 登录选项卡

  3. 在“连接属性”选项卡的“连接到数据库”文本框中,选择或输入“SSISDB”,然后选择“连接” 。On the Connection Properties tab, in the Connect to database text box, select or enter SSISDB, and then select Connect.

    SSIS 连接属性选项卡

  4. 在“SSMS 对象资源管理器”中,展开“Integration Services 目录”节点,再展开“SSISDB”,如果尚不具有文件夹,则右键单击“SSISDB”,然后创建一个新文件夹 。In the SSMS Object Explorer, expand the Integration Services Catalogs node, expand SSISDB, and if there are no existing folders, then right-click SSISDB and create a new folder.

  5. 在“SSISDB”下,展开任意文件夹,右键单击“项目”,然后选择“部署项目” 。Under SSISDB, expand any folder, right-click Projects, and then select Deploy Project.

    已展开 SSIS SSISDB 节点

  6. 在“Integration Services 部署向导”中的“简介”页上,查看信息,然后选择“下一步” 。In the Integration Services Deployment Wizard, on the Introduction page, review the information, and then select Next.

    “部署向导简介”页

  7. 在“选择源”页上,指定想要部署的现有 SSIS 项目。On the Select Source page, specify the existing SSIS project that you want to deploy.

    如果 SSMS 也连接到托管源 SSISDB 的 SQL Server,选择“Integration Services 目录”,然后在目录中输入服务器名称和项目路径以直接部署项目。If SSMS is also connected to the SQL Server hosting the source SSISDB, select Integration Services catalog, and then enter the server name and project path in your catalog to deploy your project directly.

    或者,选择“项目部署文件”,然后指定到现有项目部署文件 (.ispac) 的路径以部署项目。Alternately, select Project deployment file, and then specify the path to an existing project deployment file (.ispac) to deploy your project.

    “部署向导选择源”页

  8. 选择“下一步”。Select Next.

  9. 在“选择目标”页上,指定项目目标。On the Select Destination page, specify the destination for your project.

    a.a. 在“服务器名称”文本框中,输入完全限定的 Azure SQL Database 服务器名称 (<server_name>.database.chinacloudapi.cn)。In the Server name text box, enter the fully qualified Azure SQL Database server name (<server_name>.database.chinacloudapi.cn).

    b.b. 提供身份验证信息,然后选择“连接”。Provide the authentication information, and then select Connect.

    “部署向导选择目标”页

    c.c. 选择“浏览”以在 SSISDB 中指定目标文件夹,然后选择“下一步” 。Select Browse to specify the destination folder in SSISDB, and then select Next.

    备注

    仅在已选择“连接”后“下一步”按钮才会启用 。The Next button is enabled only after you've selected Connect.

  10. 在“验证”页上,查看任何错误/警告,然后如有必要,请修改相应的包。On the Validate page, view any errors/warnings, and then if necessary, modify your packages accordingly.

    “部署向导验证”页

  11. 选择“下一步”。Select Next.

  12. 在“查看”页上,查看部署设置。On the Review page, review your deployment settings.

    备注

    可以通过选择“上一步”或选择左侧窗格中的任意步骤链接来更改设置。You can change your settings by selecting Previous or by selecting any of the step links in the left pane.

  13. 选择“部署”启动部署进程。Select Deploy to start the deployment process.

  14. 完成部署进程后,可查看“结果”页,其中显示每一次成功或失败的部署操作。After the deployment process is completed, you can view the Results page, which displays the success or failure of each deployment action. a.a. 如果任何操作失败,请在“结果”列中选择“失败”以显示错误说明 。If any action failed, in the Result column, select Failed to display an explanation of the error. b.b. (可选)选择“保存报表”以将结果保存到 XML 文件。Optionally, select Save Report to save the results to an XML file.

  15. 选择“关闭”以退出 Integration Services 部署向导。Select Close to exit the Integration Services Deployment Wizard.

如果在没有失败的情况下成功部署项目,则可以选择该项目包含的任意包以在 Azure-SSIS IR 上运行。If the deployment of your project succeeds without failure, you can select any packages it contains to run on your Azure-SSIS IR.