Demo
Check out these brief demonstrations to understand the functionality of SSIS Catalog Migration Wizard across different scenarios of SSISDB management.
Migrate SSISDB from one SQL Server to another.
Use cases
- Migrate SSISDB from SQL Server (2012, 2014, 2016, 2017, 2019, 2022, Azure SQL MI, Azure SSIS IR) to SQL Server (2012, 2014, 2016, 2017, 2019, 2022, Azure SQL MI, Azure SSIS IR).
Export and Import SSISDB between two SQL Servers in different networks or domains.
Use cases
- Source SQL Server and target SQL Server are in different networks and can be connected through different machines.
- Source SQL Server and target SQL Server use different domain accounts to connect to the Integration Services Catalog.
- Keep a backup of SSISDB to be restored later to some other SQL Server (SSISDB).
Copy SSIS Environment from one SQL Server to another.
Use cases
- Copy only SSIS Environment to another SSISDB and update its variable strings as per the target environment.
Copy SSISDB objects on the same server but in different folders.
Use cases
- Create a test environment based on the current dev environment on the same SQL Server SSISDB but in different folders.