Migrate your SSIS Catalog in less than 5 mins!!
SSIS Catalog Migration Wizard helps you migrate full or part of the SSIS catalog to another SQL server. You can move the SSIS catalog to another server between any version of SQL Server (2012, 2014, 2016, 2017, 2019, Azure Data Factory/ Azure SQL Database, or Azure SQL managed instance). Apart from one-time migrations, this tool is designed to help you in managing day-to-day SSIS catalog activities with ease. It also provides a command-line utility to automate routine deployments or migrations.
Compare source and target catalog
Compare source and target and choose to migrate only what has changed.
Customize SSIS folder names on the go
Easily map source and target folder names. The wizard populates all selected folder names in Source and Target folder columns. Edit the value in the ‘Target Folder’ column if you wish to customize the folders.
Replace SSIS environment variable values on the go
Configure the key-value pairs that you would like to replace in the environment variable and parameter values. Suggest button will list suggestions for replacing values based on the selected Replace Scope.
Export, import or delete SSISDB items in bulk
Whether you want to keep the backup of SSIS catalog items or migrate SSISDB items to a different network, SCMW file export has this covered.
Inspect existing SSISDB for issues
Detect some trivial issues in your SSISDB like
Migrate catalog items to the same server
Migrate SSIS Catalog items on the same SQL server but to different folders.
Automate activities using the command-line utility.
With the command-line utility, we can now automate routine migrations in a matter of a few clicks. The migration script can be integrated with any scheduler or CI-CD tool.
Validate migrated projects automatically
You can choose to validate all the migrated projects automatically after their migration.
How to install
SSIS Environment Design Patterns 3 ways to set up your SSIS Catalog.
Copy SSIS Environments from one SQL Server to another. Migrate SSIS Catalog environments in just a few clicks.
You can download the SSIS Catalog comparison report in CSV format. The report shows Project's latest deployment date, SSIS package count, project parameter count, and environment variable count comparison.
Trusted by Leading Brands Worldwide