MS SQL Change Data Capture
I am looking to capture all changes in a MS SQL using Nifi. I know there is a CaptureChangeMySQL but is anyone doing anything for MSSQL? I was investigating the built in mssql cdc system and i could query the cdc.fn_cdc_get_net_changes_dbo_"TABLE NAME". Looking at thsi table i see it has all the changes i need. It also tells me what changes i need. Is anyone doing anything like this?
Posted May 22, 2023, 1:19 AM UTC
33