SSIS Catalog Migration Wizard

Migrate your entire SSISDB
in just a few clicks

Stop spending days on manual SSIS migrations. SSIS Catalog Migration Wizard Pro moves your packages, environments, parameters, and permissions to any SQL Server — automatically, accurately, every time.

SSMS 18 – 22 Visual Studio 2017 – 2026 SQL Server 2012 – 2025 Azure ADF IR Works fully offline
★ 5
VS Marketplace rating
9,000+
Downloads
Expert
Engineer support
Trusted by data & BI teams at
What it does

Everything you need for a clean SSISDB migration

From a single folder to a full enterprise catalog — the Wizard handles every scenario, automatically.

🔄
Full catalog migration in one pass

Folders, .ispac files, environments, environment variables, project and package parameters, connection strings, and explicit permissions — migrated completely, in the right order.

🔍
Pre-migration inspection & health check

Catch broken environment variable references and orphaned configurations before migration starts. Export a full inspection report as CSV to fix issues upstream.

🔒
Runs entirely inside your network

All connections are direct SQL API calls within your own network — zero data ever leaves it. For airgapped or cross-domain moves, export the catalog to a .scmw file and import it on the target machine instead.

🤖
CLI automation + CI/CD integration

Automate SSISDB migrations and backups via command-line. Integrates with SQL Agent jobs, Azure DevOps, GitHub Actions, and any CI/CD scheduler — no UI required.

⚙️
Smart environment variable replacement

The wizard proactively suggests replacement values for connection strings, file paths, and credentials — so your packages run correctly in the target environment without manual edits.

📊
Source vs target catalog comparison

Compare source and target SSISDB side by side. Green = new, red = changed. Migrate only what has changed — perfect for incremental dev-to-production deployments.

How It Works

A guided wizard — from connection to completion

Follow the same simple workflow you'll use in the real application. Each step shows you exactly what to expect before you start.

Watch a Quick Demo
1
2
3
4
5
6
7
Step 1

Choose your source

Select the SQL Server radio button and provide the SQL Server instance that hosts your SSISDB catalog.

  • Provide the source SQL Server instance name.
  • Connect using Windows Authentication.
  • The connecting user must hold the ssis_admin role.
Step 2

Choose your target

Select the Azure Data Factory radio button and point the wizard to the destination catalog for your SSIS projects.

  • Provide the Azure SQL Server hostname.
  • Enter the admin SQL Server authentication username and password.
  • Only SQL authentication is supported for the Azure SQL Server connection.
Step 3

Select catalog items to migrate

Browse the SSISDB catalog treeview and choose exactly which folders, projects and environments to move.

  • Compare source and target — changed items are flagged for review.
  • Optionally migrate only project references and parameter values.
  • Choose migration type: copy (default) or move.
  • Optionally migrate explicit folder, project and environment permissions.
Step 4

Customize folder mapping

The wizard pre-populates source and target folder names — edit the Target Folder column to rename or consolidate as needed.

  • Rename target catalog folders during migration.
  • Map source folders to different target names.
  • Consolidate multiple source folders into one target folder.
  • This step is optional.
Step 5

Replace variables & parameters

Configure key-value replacements so environment variables and project or package parameters line up with the target environment.

  • Use Suggest for recommendations based on the selected Replace Scope.
  • Click the Ref column to review detailed variable and parameter mappings.
  • Common use case: updating a SQL Server connection string for the target.
  • Ideal for standing up a parallel ETL environment without manual edits.
Step 6

Review & confirm

Before anything is committed to the target catalog, review the full deployment summary and make sure everything is ready.

  • Confirm the source and target selections.
  • Review the selected SSISDB catalog items.
  • Double-check folder mapping and variable replacements.
  • Click Finish once the summary looks correct.
Step 7

Migrate & monitor

The wizard performs the migration and reports results live — folder by folder — as the catalog is deployed to the target.

  • Monitor progress through the live migration grid.
  • Hover the Result column to see warnings or errors per folder.
  • Successful items are marked "Passed".
  • Verify your SSISDB catalog was transferred successfully.
Customer Reviews

What our customers are saying

Real feedback from database administrators and IT teams running the wizard in production.

DevOps integration

Automate your SSIS deployments via CLI

Annual and Perpetual plans include the SCMW command-line utility. Schedule migrations, run them in CI/CD pipelines, or automate nightly SSISDB backups — no UI required.

Works with SQL Agent jobs — schedule regular SSISDB backups or incremental deployments

Azure DevOps & GitHub Actions — integrate SSISDB deployment into your release pipeline

Selective item migration — specify exactly which folders, projects, and environments to migrate

Custom log file location — full execution logs saved to a path you specify for audit trails

Example CLI commands
# Full catalog migration, source → target
SSIS.Cataloger.Pro.exe /st:0 /ssn:SourceServer /tt:0 /tsn:TargetServer

# Export SSISDB to .scmw backup file
SSIS.Cataloger.Pro.exe /st:0 /ssn:. /tt:2 \
  /scmwfp:"D:\Backups\backup.scmw"

# Selective migration + log output
SSIS.Cataloger.Pro.exe /st:0 /ssn:SourceServer \
  /tt:0 /tsn:TargetServer \
  /items:"[{FolderName:Sales}]" \
  /lfd:"D:\Logs"

Full CLI reference: ssiscataloger.azureops.org/automation →

Pricing

Choose your SSIS migration license

Select the plan that best fits your migration scope. Perpetual and Enterprise Perpetual licenses include CLI automation support for CI/CD pipelines.

placeholder
1 Month
For individual engineers or small teams migrating a single SSISDB instance.
Original price was: $499.Current price is: $249. (Flat 50% OFF)
single seat · 1-month license
Buy Now
What's included
Complete SSISDB migration — projects, packages, environments, parameters and permissions
Migration controls — selective migration, source/target comparison, folder mapping and environment/parameter updates
Migration utilities — SCMW export/import, inspection and automatic validation
placeholder
1 Year
For teams managing ongoing SSISDB migrations and environment maintenance.
Original price was: $999.Current price is: $499. (Flat 50% OFF)
single seat · 1-year license
Buy Now
Everything in 1 Month, and:
12-month license — use throughout your project cycle
Version updates — all releases during the license term
★ Recommended
Perpetual
For consultants and teams needing a permanent license with automation capabilities.
Original price was: $1799.Current price is: $899. (Flat 50% OFF)
single seat · lifetime license
Buy Now
Everything in 1 Year, and:
Lifetime license — pay once, own it forever
CLI automation — script migrations and integrate with CI/CD
Integrates with schedulers or CI/CD pipelines, including SQL Agent
Lifetime updates — every future release included
placeholder
Enterprise Perpetual
For organizations migrating across multiple servers, environments, and engineers.
Original price was: $2999.Current price is: $1499. (Flat 50% OFF)
up to 5 seats · lifetime license
Buy Now
Everything in Perpetual, and:
Up to 5 seats — cover your whole migration team on one license
License migration — move seats between machines or team members as your team changes
Priority support — direct access to the engineers who built the tool
Custom invoicing and PO numbers on request
Need more than 5 seats or custom terms? Get a quote.
✓ 100% money-back guarantee
✓ No auto-renewals
✓ Runs fully offline, inside your network
FAQ

Frequently asked questions

Can't find your answer? Email our support team →

Which SQL Server versions are supported?

SQL Server 2012, 2014, 2016, 2017, 2019, 2022, and 2025 — as source or target. Also supports Azure Data Factory SSIS Integration Runtime and Azure SQL Managed Instance.

How many licenses do I need?

One license per installation server. If your source and target SSISDB are both reachable from one machine, you only need one license. The tool grants multi-user access per server.

Does the tool require an internet connection?

No. SSIS Catalog Migration Wizard works fully offline. All connections are direct SQL API calls within your own network. Zero data is ever sent to any external server.

Can I migrate across different networks or domains?

Yes. Use the .scmw export format: export the source catalog to a file, copy it to the target network, and import it there. Install the tool on both machines.

Does it migrate encrypted passwords?

Yes. The wizard handles encrypted connection manager properties and sensitive environment variables. Sensitive data export can also be controlled via settings.

Are discounts available for education or non-profits?

Yes — exclusive discounts for educational institutions and non-profit organisations. Email support@azureops.org from your official address for the discount code.

Ready to migrate your SSISDB without the pain?

Try free from Visual Studio Marketplace, or buy direct with our 100% money-back guarantee.

View Pricing