How to move dataset from Azure Managed Instance to Azure SQL using SSIS with change data capture

Shubhi Jain 21 Reputation points
2021-07-01T08:08:14.403+00:00

How to move data from Azure Managed Instance to Azure SQL Database by using SSIS package with Change data capture feature in it? Please help me with links or documents

Azure SQL Database
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
717 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,081 Reputation points Microsoft Employee
    2021-07-02T16:54:03.34+00:00

    Hi @Shubhi Jain You can now move your SQL Server Integration Services (SSIS) projects, packages, and workloads to the Azure cloud. Deploy, run, and manage SSIS projects and packages on Azure SQL Database or SQL Managed Instance with familiar tools such as SQL Server Management Studio (SSMS). This article highlights the following specific areas when using Azure SQL Managed Instance with Azure-SSIS integration runtime. Please refer to Azure SQL Managed Instance with SQL Server Integration in ADF for more details.
    Regards,
    Oury

    1 person found this answer helpful.