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

123 Views Asked by At

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.

1

There are 1 best solutions below

0
On

Good news, CDC was implemented for Managed Instance and Azure SQL Database as per yesterday:

"Change data capture (CDC) records insert, update, and delete activity that applies to tables in SQL Server, Azure SQL Managed Instance or Azure SQL Databases [...]"

You can see some common scenarios in this video.