Post-SSIS Migration from 2012 to 2019

Ardan Zaki 236 Reputation points
2022-11-07T10:05:32.41+00:00

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
    2022-11-07T13:39:18.22+00:00

    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