What is the recommended approach to migrate SSIS and related packages from sql server 2016 to sql server 2019?



  • 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?


  • 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: https://www.sqlshack.com/how-to-retrieve-information-about-ssis-packages-stored-in-msdb-database/




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2