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,456 questions
0 comments

6 answers

Sort by: Newest
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
  2. Monalv-MSFT 5,896 Reputation points
    2020-09-11T09:25:26.913+00:00

    Hi @NeophyteSQL ,

    We can deploy the SSIS projects from server1 SSIS catalog to server2 SSIS catalog. In this way, we need to create the environments manually.
    Please refer to the following pictures:
    24131-select-source.png

    24095-select-destination.png

    24089-review.png

    24048-result.png

    Best Regards,
    Mona

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. Yitzhak Khabinsky 25,106 Reputation points
    2020-09-08T17:22:05.717+00:00

    Hi sqlniks-7244,

    1. You could backup and restore the entire SSISDB database.
      If you are migrating from the earlier version of SSIS, you would need to run 'Database Upgrade' wizard in the Integration Services Catalogs after that. Right mouse click on top of the SSISDB entry will show that option.
    2. There is a commercial software (not free) to that: ssis-catalog-compare-v4
    0 comments
  4. NeophyteSQL 241 Reputation points
    2020-09-08T05:56:26.22+00:00

    can you pls elaborate why monas solution wont work.

    pros and cons of each methodology applied

  5. NeophyteSQL 241 Reputation points
    2020-09-04T14:25:10.07+00:00

    ssis projects folder needs to be copied over to the new server and then deployed

    is this going to create the environments and projects as old server