Data Migration Assistant (DMA) is released to provide migration assessment of SSIS packages
Published Nov 12 2019 06:17 PM 8,636 Views
Microsoft

 

When you migrate your database workloads from SQL Server on premises to Azure database services, namely Azure SQL Database or Azure SQL Database managed instance, your ETL workloads on SQL Server Integration Services (SSIS) as one of the primary value-added services will need to be migrated as well. Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF) supports running SSIS packages.  

 

To establish a complete migration plan, a thorough assessment will help identify issues with the source SSIS packages that would prevent a successful migration.

 

Data Migration Assistant (DMA) is a freely downloadable tool for this purpose that can be installed and executed locally. DMA assessment project of type Integration Services can be created to assess SSIS packages in batches, identify compatibility issues and provides recommendations to help you address those issues.

dma.png

 

To performance SSIS packages assessment using DMA, download and install the latest version of the tool from the Microsoft Download Center, and then perform the assessment.

Version history
Last update:
‎Nov 12 2019 06:17 PM
Updated by: