SSIS migration to Azure SQL MI using DMS

Nilesh Patel 111 Reputation points
2022-01-25T11:32:40.407+00:00

We have a On-premise SQL server which is having Database Engine and Integration Service. We are planning to migrate Databases alone to Azure SQL MI using DMS and SSIS packages later (after 1 month) using DMS. Pls confirm if it will impact anything in Database Engine and if there is any link between them, If yes how to check it.

Thanks,
Nilesh

Azure Database Migration service
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
716 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 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.
492 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2022-01-26T01:07:18.15+00:00

    Hi @Nilesh Patel Thank you for posting your Question on Microsoft Q&A forum.

    It should not have any impact on the database engine. SSIS are in a separate SSISDBs. The only link would be SSISDB running on the same SQL Server engine running user databases.

    Migrate SQL Server Integration Services packages to an Azure SQL Managed Instance

    Regards,
    Oury

    1 person found this answer helpful.
    0 comments
  2. ZoeHui-MSFT 32,426 Reputation points
    2022-01-26T01:32:03.337+00:00

    Hi @Nilesh Patel ，

    You may also refer this for more details.

    This article focuses on the migration of SQL Server Integration Service (SSIS) packages stored in SSIS catalog (SSISDB) and SQL Server Agent jobs that schedule SSIS package executions.

    scenario-ssis-migration-ssisdb-mi

    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