Is it possible to move SSISDB to another

Jonny-4280 80 Reputation points
2024-03-26T05:47:16.8433333+00:00

I have two machine both installed SQL SERVER2019, I want to move the SSISDB from A machine to another.

Is it possible? How can i do that?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 36,511 Reputation points
    2024-03-26T05:57:33.2333333+00:00

    Hi @Jonny,

    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

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.