question

CarlosPereira-5753 avatar image
0 Votes"
CarlosPereira-5753 asked Monalv-msft edited

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

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://docs.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

sql-server-integration-servicessql-server-migrationsql-server-migration-assistant
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @CarlosPereira-5753 ,

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @CarlosPereira-5753 ,

May I know if you have anything to update?

Best regards,

Mona

0 Votes 0 ·
CarlosPereira-5753 avatar image
0 Votes"
CarlosPereira-5753 answered Monalv-msft commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @CarlosPereira-5753,

Welcome to put up your need in the SQL Server Feedback Forum.

Best regards,
Mona

0 Votes 0 ·
SiddharthKrishna-8267 avatar image
0 Votes"
SiddharthKrishna-8267 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarlosPereira-5753 avatar image
0 Votes"
CarlosPereira-5753 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.