This blog is part of the Change Data Capture in Azure SQL Databases Blog Series, which started with the announcement on releasing CDC in Azure SQL Databases in early June 2021. You can view the relea...
Published Jul 09, 2021
Version 1.0
Blog Post
6 MIN READ
Using Change Data Capture and Azure Data Factory to Incrementally Load Change Data
Great article. I did have an issue with this command: SELECT count(1) changecount FROM cdc.fn_cdc_get_all_changes_dbo_customers(@from_lsn, @sto_lsn, 'all')
I think that extra s in @sto_lsn needs to be just @to_lsn. Thanks.