Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have SSIS packages in msdb database as well as in the ssis catalog (ssis db).
What is the recommended approach to migrate SSIS and related packages from sql server 2016 to sql server 2019?
For example -
Wow...sorry but so much bad advice here. First don't upgrade in place as a best practice due to carrying over old versions of software...rather create a new fresh server and deploy and test there. Second, the upgrade wizard hasn't been supported for years since 2016 unless you're upgrading an earlier version than that. Why are people still saying to use it is beyond me (it'll just show list of no packages to upgrade - have fun with that). Third, upgrading takes place in VS/SSDT and happens twice, once when you change deployment to 2019 version and then when you open every package. And every package you open takes a millenium to open. So far I've found no workaround for that.
There is an upgrade SSISDB wizard - I wouldn't do that because again you're upgrading existing rather than starting new which inherits any legacy debt on your server.
Option 1 and 2 are good options for ssisdb.
About the dtsx in the msdb, those usually come from wizards like import/export features in ssms or maintenace plans.
If you need them for sure it's quite complicated.
here you can find a good guide: link
