sql server 2016 migrate ssis packages including environments deployed to catalog

NeophyteSQL 241 Reputation points
2020-09-04T06:16:30.757+00:00

I have ssis packages deployed to ssis catalog.

I need to move the projects along with the environemnts to new server sql 2016

can anyone please guide how to accomplish this

thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,457 questions
0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Kunal Rathi 6 Reputation points
    2020-11-27T09:02:19.217+00:00

    You could try using the SSIS Catalog Migration Wizard extension for (SQL Server Management Studio) SSMS 2018 from Visual Studio Marketplace.

    43196-ssmsoption.jpg

    If you have Visual Studio 2017 or 2019, you could also use it as an extension as shown in the below image.

    43208-vsmarketplacedownload.png

    This easy-to-use utility can help you migrate your SSIS Catalog (SSISDB) items in just a few clicks.

    If the response is helpful, please click Accept Answer and upvote it.

    0 comments