Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory

Discover how to accelerate the migration of legacy SQL Server and SQL Server Integration Services (SSIS) to the cloud using Azure Data Factory (ADF) in this comprehensive conference talk. Learn the process of provisioning Azure-SSIS Integration Runtime (SSIS-IR) and extending it with custom and third-party components. Explore techniques for running SSIS packages stored in file systems as first-class activities within ADF pipelines. Gain insights into accessing Azure SQL Database Managed Instance using OLEDB connectors configured for Azure Active Directory (AAD) authentication and Virtual Network (VNet). Delve into the complete SSIS Migration Playbook, covering batch package assessments, package migrations, and job migrations using Data Migration Assistant (DMA) and Data Migration Service (DMS). This 75-minute session, recorded at PASS Summit 2019, provides valuable knowledge for IT professionals looking to streamline their cloud migration processes.