Physical Modeling › New r8 SQL Server 2008 Support in CA ERwin Data Modeler › Change Data Capture

Change Data Capture

Change data capture tracks database changes asynchronously and exposes the changes using a relational interface. With this relational interface you can easily track changes based on your specific requirements, and then consume the change data using the data access method you choose. In CA ERwin Data Modeler, the change data capture object provides the specifications for capturing changes to data stored in a table. A table can have up to two specifications for data capture.

Use the following process to work with change data capture:

• Define properties for change data capture objects.
• Enable change data capture functionality in the SQL Server 2008 database that contains the tables that require change data capture.
• Define change data capture settings for a SQL Server 2008 table.