Migrate SSISDB Integration Service Catalog

Question

Hi Expert,

My organization plan to migrate SQL instance to new system, there is many project folder in Integration Service Catalogs - SSISDB

I've got idea to migrate project folder on this part at once to minimizing migration time duration

if any, is there tricks or tips and how do it?

great thanks and appreciation for all

Warm regards,

Urbel

Answer 1

Hi @UrBel

You can follow the steps in the documentation To Move the SSIS Database as it has some additional good precautions noted:

Follow the instructions for moving user databases. For more information, see Move User Databases. Ensure that you back up the master key for the SSISDB database and protect the backup file. For more information, see To Back up the SSIS Database.

You may also check the article step by step.

Moving the SSISDB Catalog on a new SQL Server instance

Also, here is a tool named SSIS Catalog Migration Wizard to that.

https://www.mssqltips.com/sqlservertip/6831/how-to-migrate-ssisdb-to-another-server/

Regards，

Zoe Hui