dbatools is a free PowerShell module with over 300 SQL Server administration, best practice and migration commands included.

Please note that documentation and command names may be out of date while we work furiously towards 1.0


This command migrates Folders, SSIS projects, and environments from one SQL Server to another.

By default, all folders, projects, and environments are copied. The Project parameter can be specified to copy only one project, if desired.
The parameters get more granular from the Folder level i.e. specifying folder will only deploy projects/environments from within that folder.


Output when SSIS catalog already exists


If SSIS is not yet setup, the script can set it up for you



To copy all folders, environments and all ssis Projects from sqlserver2014a to sqlcluster, using Windows credentials. If folders with the same name exist on the destination they will be skipped, but projects will be redeployed.


To copy a single Project, the Archive_Tables Project from sqlserver2014a to sqlcluster, using SQL credentials for sqlserver2014a and Windows credentials for sqlcluster. If a Project with the same name exists on sqlcluster, it will be deleted and recreated because -Force was used.


To show what would happen if the command were executed using force.


To deploy an entire SSIS catalog to an instance without a destination catalog. Passing -CreateCatalogPassword will bypass any user prompts for creating the destination catalog.



This command was created by Phil Schwartz. You can find Phil Schwartz blogging and on LinkedIn.


From PowerShell, execute Get-Help Copy-DbaSsisCatalog -Detailed for more information on this function.

Source Code

Want to see the source code? View Copy-DbaSsisCatalog.ps1 on GitHub

Related commands