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


Copy-DbaSsisCatalog

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.

Screenshots

Output when SSIS catalog already exists

copy-sqlssiscatalog1

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

copy-sqlssiscatalog2

Examples

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.

 

Author

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

Get-Help

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