SQL Server Change Tracking Demo Using Multiple Tracking Tables
Discover how to manage database schema evolution without losing your historical data tracking in SQL Server Change Data Capture (CDC).
In this step-by-step technical demo, we explore how SQL Server natively handles columns added to a source table by utilizing multiple capture instances. We’ll walk through the strict "Two-Instance Limit" rule and show you the exact strategy needed to transition from older tracking tables to a newer schema version without disrupting your data pipeline.
What you’ll learn in this video:
How the first capture instance (V1) behaves when an ALTER TABLE statement introduces new columns.
Enabling a second concurrent capture instance (V2) to capture new column data alongside the old schema.
Navigating the maximum two-instance ceiling when a third schema change (V3) is required.
The correct workflow to safely disable an obsolete capture instance (sys.sp_cdc_disable_table) to free up a slot for the next iteration.
If you work with enterprise data integration, SSIS, Kafka connectors, or Azure Data Factory streams relying on SQL Server CDC, mastering this transition workflow is essential for zero-downtime schema updates.
Don't forget to Like, Comment, and Subscribe for more deep dives into SQL Server internals, database architecture, and performance tuning!
0:00 - Initial Setup & Enabling Database CDC
1:00 - Creating the First Capture Instance (V1)
3:00 - Tracking Inserts, Updates, and Deletes
3:40 - Adding a Column & Enabling a Second Instance (V2)
5:15 - Exceeding the Limit: Disabling V1 to Create a Third Instance (V3)
8:00 - Summary & Best Practices for Production Schema Changes
#SQLServer #ChangeDataCapture #SQLCDC #DatabaseSchema #SQLServerDBA #DataEngineering #TSQL #DatabaseAdministration #SQL #DBA #DataPipelines
On this page of the site you can watch the video online SQL Server Change Tracking Demo Using Multiple Tracking Tables with a duration of hours minute second in good quality, which was uploaded by the user Neil Bryan 25 June 2026, share the link with friends and acquaintances, this video has already been watched 15 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
