Share via

SQL Server SSIS package migration from MSDB database to Azure SQL MI

Santhamoorthy M 161 Reputation points
2022-02-28T04:26:53.87+00:00

Hi,

We have lot of Integration service packages under MSDB Database and need to migrate those package to Azure SQL MI. We tried it with Azure DMS but its not supporting package deployment model. Could someone please guide me on the migration steps and prerequisites.

SQL Server version 2012.

Thank you
Santhamoorthy

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
768 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-02-28T06:25:50.027+00:00

    Hi @Santhamoorthy M ,

    Here is an official documentation about Migrate SQL Server Integration Services packages to an Azure SQL Managed Instance, you may take a reference to.

    how-to-migrate-ssis-packages-managed-instance

    Regards，

    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

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.