以 Azure SQL 数据库托管实例为数据库工作负荷目标的 SSIS 迁移SSIS migration with Azure SQL Database managed instance as the database workload destination

将数据库工作负荷从本地 SQL Server 迁移到 Azure SQL 数据库托管实例时,应熟悉 Azure 数据迁移服务 (DMS) 和使用 DMS 进行的 Azure SQL 数据库托管实例迁移的网络拓扑When migrating database workloads from SQL Server on premises to Azure SQL Database managed instance, you should be familiar with Azure Data Migration Service(DMS), and the network topologies for Azure SQL Database 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 包迁移到 Azure SQL 数据库托管实例SSISDB migration can be done using DMS, as described in the article: Migrate SSIS packages to an Azure SQL Database managed instance.

从 SSIS 作业到 Azure SQL 数据库托管实例代理SSIS jobs to Azure SQL Database managed instance agent

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

其他资源Additional resources

后续步骤Next steps