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.
925 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
    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.

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.