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.
Asked
Active
Viewed 87 times
0
shubhi jain
- 29
- 3
-
There is no CDC in Azure SQL Database yet. If possible, could you please let me know more about the use case. If the object is just to move the data, you can use other tools. Any specific reason to use CDC, SSIS? – Utkarsh Pal Jul 01 '21 at 18:11
1 Answers
0
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.
Francesco Mantovani
- 10,216
- 13
- 73
- 113