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 -
- Do I need to backup and restore the ssisdb?
- or do I need to re-create the ssis catalog that will auto create the new ssisdb followed by manual deployment of the ssis packages?
- How to handle ssis packages in the msdb?