将 Azure SQL 托管实例作为数据库工作负荷目标的 SSIS 迁移SSIS migration with Azure SQL Managed Instance as the database workload destination

适用于:是 Azure 数据工厂否 Azure Synapse Analytics(预览版)APPLIES TO: yesAzure Data Factory noAzure Synapse Analytics (Preview)

将数据库工作负荷从 SQL Server 实例迁移到 Azure SQL 托管实例时,应熟悉 Azure 数据迁移服务 (DMS) 和使用 DMS 进行 SQL 托管实例迁移的网络拓扑When migrating database workloads from a SQL Server instance to Azure SQL Managed Instance, you should be familiar with Azure Data Migration Service(DMS), and the network topologies for SQL Managed Instance migrations using DMS.

本文重点讨论如何迁移存储在 SSIS 目录 (SSISDB) 中的 SQL Server Integration Service (SSIS) 包以及用于计划 SSIS 包执行的 SQL Server 代理作业。This article focuses on the migration of SQL Server Integration Service (SSIS) packages stored in SSIS catalog (SSISDB) and SQL Server Agent jobs that schedule SSIS package executions.

迁移 SSIS 目录 (SSISDB)Migrate SSIS catalog (SSISDB)

SSISDB 迁移可以使用 DMS 来完成,如下文所述:将 SSIS 包迁移到 SQL 托管实例SSISDB migration can be done using DMS, as described in the article: Migrate SSIS packages to SQL Managed Instance.

将 SSIS 作业迁移到 SQL 托管实例代理SSIS jobs to SQL Managed Instance agent

SQL 托管实例有一个一流的本机计划程序,就像本地 SQL Server 代理一样。SQL Managed Instance has a native, first-class scheduler just like SQL Server Agent on premises. 由于适合 SSIS 作业的迁移工具尚未发布,因此必须通过脚本/手动复制方式将 SSIS 作业从本地 SQL Server 代理迁移到 SQL 托管实例代理。Since a migration tool for SSIS jobs is not yet available, they have to be migrated from SQL Server Agent on premises to SQL Managed Instance agent via scripts/manual copy.

其他资源Additional resources

后续步骤Next steps