Hi @Prajapati, Jinal ,
You may refer to this article.
https://www.sqlshack.com/moving-the-ssisdb-catalog-on-a-new-sql-server-instance/
To migrate SQL Server agent job, transfer-jobs-task is a good choice to do that.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Experts,
Happy Thursday!
I need a bit of guidance on SSIS packages & SQL server JOB migration. We recently upgraded our SQL SERVER instance to 2019. What would be the best approach to migrate SSIS packages and SQL server agent jobs to the new instance?
I would appreciate your comments.
Look forward to your reply!
Regards,
Jinal
Hi @Prajapati, Jinal ,
You may refer to this article.
https://www.sqlshack.com/moving-the-ssisdb-catalog-on-a-new-sql-server-instance/
To migrate SQL Server agent job, transfer-jobs-task is a good choice to do that.
Hi @Prajapati, Jinal ,
Like AveryTang-7680 said, to migrate SQL Server agent job, it is more suitable to use transfer-jobs-task in SSIS.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.