Migrate or Copy SSIS Package From Database MSDB

Question

Hi all,

Currently we are migrating SQL server from version 2012 to 2019 with side-by-side method.
On our existing SQL server there are hundreds of ssis packages contained in the msdb database.

We want to copy those packages to our new SQL server, but we only know how to copy those packages one by one using dtutil.
is there any other way that we can use to copy the packages at once?

Really appreciate for your answer!

Answer 1

Hi @Arief Hardiansyah ,
The SQL Server Data Tools (SSDT) maybe a good choice. you can create a SSIS project in SQL Server Data Tools, then right-click the Project name in the Solution Explorer tab, then select “Add Existing Item” option to select all packages from other projects.

After loading and upgrading all packages in one project, you can directly deploy the project to SSISDB database in SSDT or install all packages to MSDB.
https://learn.microsoft.com/en-us/sql/integration-services/lesson-6-4-deploying-the-lesson-6-package?redirectedfrom=MSDN&view=sql-server-ver16
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms140117(v=sql.105)?redirectedfrom=MSDN

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"