How to use dtutil to migrate SSIS packages when SSISDB is used instead of MSDB?
I'm trying to use dtutil to automate the migration of hundreds of packages from SQL Server 2016 to SQL Server 2019 in another server.
It seems dtutil is unable to find the project/package folder.
All I found in docs and links seems to refer to msdb, but here, the folder/project/package data is stored in SSISDB database tables instead.
I don't think you can use DTUtil to migrate packages from SSISDB.
Based on the official documentation:
The dtutil command prompt utility is used to manage SQL Server Integration Services packages. The utility can copy, move, delete, or verify the existence of a package. These actions can be performed on any SSIS package that is stored in one of three locations: a Microsoft SQL Server database, the SSIS Package Store, and the file system.
Alternatives
There are several alternatives to migrate SSIS projects from SSISDB to another instance such as backup and restoring the SSISDB database, using a third-party solution, or using the Package import wizard.
You can refer to the following articles for more information:
- I can't use my declare @AverageValue in SQL Server
- How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
- Is there a way to get a list of all current temporary tables in SQL Server?
- SUM for multiple condition with 2 tables in one query
- What happens to Transaction if TransactionScope.Complete not called at the end of the Using block
- How to create a table in SQL Server with PRIMARY as the column name?
- Cannot connect my ASP.NET Web API to SQL Server on macOS (Docker) – "Cannot connect to SQL Server Browser"
- How to have docker compose init a SQL Server database
- UPDATE with a one-to-many JOIN (multiple columns)
- How to execute mathematical expression stored in a varchar variable
- Connect to SQL Server with Windows authentication from a Linux machine through JDBC
- Databricks Spark SQL Column Compatibility Problem
- Why date comparison is not working in this SQL query?
- SQL Server select query where clause
- Bulk Update in C#
- How do I use Poor Man's T-SQL Formatter in SSMS v20?
- SQL Server spatial and linked servers
- Custom Aggregate Function (to use with GROUP BY)
- Is it possible to exploit a query via SQL Injection when the input is stripped of all apostrophes?
- How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
- Replace duplicate spaces with a single space in T-SQL
- SQL Server TRY...CATCH with XACT_STATE
- Sql Server Network Configuration Protocols Not Available
- Pad a string with leading zeros so it's 3 characters long in SQL Server 2008
- Compare values in 2 tables and output the different field's names in a single column?
- check pdo php insert success
- Connecting Django with MSSQL server
- Diff between Top 1 1 and Select 1 in SQL Select Query
- SQL count rows in a table
- Sort rows by latest group