This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 12%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Ardan Zaki ,
Please refer to the following article: how-to-migrate-ssisdb-to-another-server
It outlines all possible methods for your task.
I actually refer to that article to migrate my SSIS packages, What I am asking is the next step to test the packages and whether there're some steps to complete the migration so I can run the packages just like the old server.
Run the package in SQL Server2019 catalog to see if the migration has been completed.