Title: Tracking data changes with CDC in SQL Server 2008
Duration: 17:49 min.
Summary: Until SQL Server 2008 developers need to create their own implementation to track data and structural changes in a table. However, SQL Server 2008 has a new feature called CDC (Change Data Capture) that allows a developer to capture data and structure modifications directly from the transaction log. This video explain how to enable the CDC feature, check the metadata, roles, jobs and schema created automatically and also shows an example of how the data is tracked. With this feature developers can rely on an automatic mechanism to track modifications in tables, avoiding the development of specific programming routines to track the changes in tables.
Technologies: SQL Server, CDC
Methodology: This video uses examples to explain how to enable and disable the CDC (Change Data Capture) feature of SQL Server 2008 via T-SQL commands. The commands uses in the script are explained step by step, showing how to enable the CDC for a database and a table.
Built Examples: The video show how to enable the DCD feature for a table that has two simple columns. The video then demostrate how to track the changes made in the structure of the table and while rows are inserted, updated and deleted in the table.
Keywords: SQL Server, Data, Changes.