0

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 -

  1. Do I need to backup and restore the ssisdb?
  2. 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?
  3. How to handle ssis packages in the msdb?
1

1 Answer 1

-1

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

7
  • Does backup and restore of the ssisdb auto create the SSIS catalog?
    – variable
    Apr 13 at 11:06
  • @MBuschi You cannot restore msdb backup of sql server 2016 on SQL Server 2019, so how is option 1 good ?
    – Shanky
    Apr 13 at 11:22
  • updated. for ssisdb
    – MBuschi
    Apr 13 at 11:46
  • 1
    @MBuschi But option 1 is NOT possible at all. So you need to completely remove that because as per OP he is moving from 2016 to 2019.
    – Shanky
    Apr 13 at 12:06
  • The database will be updated by the engine to the last version if you run the SSISDB Upgrade Wizard. Be sure to backup/restore encryption key too. Otherwise go for the option 2.
    – MBuschi
    Apr 13 at 12:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.