Skip to content
| Marketplace
Sign in
Visual Studio>Tools>SSIS Catalog Migration Wizard

SSIS Catalog Migration Wizard

AzureOps

|
23 installs
| (0) | Paid
SSIS Catalog Migration Wizard helps you migrate SSIS Catalog from one server to another It is an add-in for SSMS 18, 19, Visual Studio 2017, 2019 or 2022.

Documentation | Report a bug | Contact us | Get activation key

Migrate your SSIS Catalog in less than 5 mins!!

Watch this video to see how. VS_marketplace_-_how_to_migrate_SSIS_catalog.png

About

SSIS Catalog Migration Wizard helps you migrate the 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, 2022, Azure Data Factory/ Azure SQL Database, or Azure SQL managed instance). Apart from one-time migrations, this tool is designed to help you easily manage day-to-day SSIS catalog activities. It also provides a command-line utility to automate routine deployments or migrations.

ezgif.com-gif-maker.gif

Features

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. If you wish to customize the folders, edit the value in the ‘Target Folder’ column.

Replace SSIS environment variable values on the go

Configure the key-value pairs 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 or domain, SCMW file export covers this.

Inspect existing SSISDB for issues

Detect some trivial issues in your SSISDB like

  • SSIS projects have orphan environment references.
  • Project or package parameter refers to environment variables that do not exist in its reference environments.
  • Unused environments or environment variables etc.

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 automate routine migrations in 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

Watch this short video to learn more. How_to_install_SSIS_Catalog_migration_wizard_thumbnail__1.png

Latest blog

Migrate SSISDB to a different network in just a few clicks

Copy SSIS Environments from one SQL Server to another.

SSIS Environment Design Patterns

Earlier releases

2.5.1 (07/12/2022)

  • This version introduces a smart way to migrate environment variables and parameter values. This will be helpful, especially when setting up a new environment based on the existing catalog.
  • Added support for SSIS 2022 (preview).

2.4.0 (05/15/2022)

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

Clients.gif

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2023 Microsoft