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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2020-09-04T08:16:10.987+00:00

    Hi sqlniks,

    Please copy the SSIS project folder to new server.

    22588-projectsssis.png

    Best Regards,
    Mona

    ----------

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

  2. 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

  3. 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

  4. Yitzhak Khabinsky 24,941 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
  5. Monalv-MSFT 5,891 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.