Post-SSIS Migration from 2012 to 2019

Ardan Zaki 236 Reputation points

Hi, I'm new at SQL Server, I'm currently migrating SSIS Packages from SQL Server 2012 to SQL Server 2019 using backup and restore SSISDB Method and I have upgraded the database using SSISDB Upgrade Wizard. What should I do next to make sure all packages run as they should like in the old server?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,063 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,486 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 25,376 Reputation points

    Hi @Ardan Zaki ,

    Please refer to the following article: how-to-migrate-ssisdb-to-another-server
    It outlines all possible methods for your task.

0 additional answers

Sort by: Most helpful