SQL Server 2008 on-prem - CDC Fabric

Hi fabricpribeiro ,

Thank you for reaching out to the Microsoft Community Forum.

Hi tayloramy , Thank you for your prompt response.

Hi fabricpribeiro ,  Use Fabric Data pipelines  -->Copy Activity  in CDC mode instead of Copy job, CDC in Copy Job (Preview) have some limitations. Fabric Data Factory Copy Activity supports CDC deletes, it reads from the CDC tables (cdc._CT) including delete, insert, update (before) and update (after).

Note: It reads from CDC change tables (cdc.__CT), Captures __$operation and writes operation metadata into Lakehouse.

Please refer below link.

Change data capture (CDC) in Copy Job - Microsoft Fabric | Microsoft Learn

What is change data capture (CDC)? - SQL Server | Microsoft Learn

Change data capture - Azure Data Factory & Azure Synapse | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh