SSIS - DMA doesn't support migration assessment to SSIS in local SQL Server 2019

Question

Hi,

we will migrate from SQL Server 2008 R2 to SQL Server 2019 in near future, we already run DMA to analyze database, however DMA 5.2 doesn't support migration assessment type for intergration services (SSIS) when the destination server is a local SQL Server, only supports Azure SQL Database ou Azure SQL Managed Instance,

As stated in "assessment for migrating SQL Server Integration Service (SSIS) packages to Azure SQL Database or Azure SQL Managed Instance, by using Data Migration Assistant." from https://learn.microsoft.com/en-us/sql/dma/dma-assess-ssis?view=sql-server-ver15

Any alternative to evaluate SSIS code compatiblity with new version?

Only option i could find was executing DTexec with Validate parameter (and i don't know if is even similar to DMA):

/Va[lidate]: (Optional). Stops the execution of the package after the validatation phase, without actually running the package. During validation, use of the /WarnAsError option causes dtexec to treat a warning as an error; therefore the package fails if a warning occurs during validation.

Best Regards,
Carlos

Answer 1

Hi @Carlos Pereira ,

The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database.

Please refer to the following links:

1.Overview of Data Migration Assistant

2.Data Migration Assistant (DMA) is released to provide migration assessment of SSIS packages

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi, Mona,

None of the links you shared have helped me. The cenario on our case isn't available yet on DMA (assessmente for migration od SSIS from SQL 2008 R2 to SQL Server 2019).

Best regards,
Carlos

Answer 3

Check this link - https://learn.microsoft.com/en-us/sql/dma/dma-assess-ssis?view=sql-server-ver15

Answer 4

Hi, anonymous user ,

I already read the page you shared, however is restricted to "and set the target server type as Azure SQL Database or Azure SQL Managed Instance.", our migration is to SQL Server instance not Azure.

Best regards,
Carlos