This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi sqlniks,
Please copy the SSIS project folder to new server.
Best Regards,
Mona
----------
If the response is helpful, please click "Accept Answer" and upvote it.
Hi sqlniks,
After copying the project folder to new server, we can deploy the projects in SSIS catalog.
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.
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
You are right on target, Mona's suggestion will not work for you.
It is better to 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.
can you pls elaborate why monas solution wont work.
pros and cons of each methodology applied
What Mona's suggestion does it just a deployment of the SSIS project from the dev. environment in Visual Studio to a SSIS run-time environment on a server.
Though based on my understanding, you are asking how to get SSIS Environments from existing SSISDB Catalog to another server.
Hi sqlniks-7244,
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:
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.
Thanks mona
Hi @NeophyteSQL ,
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Mona