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.
755 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,521 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.
515 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 17,791 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 No comments

  2. ZoeHui-MSFT 35,381 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 No comments