Previous Topic: Define a Database in SQL Server 2008Next Topic: SQL Server 2008 Database Audit Specifications

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Server 2008 Property Editors › Define a Database in SQL Server 2008 › Enable Change Data Capture for a SQL Server 2008 Database

Enable Change Data Capture for a SQL Server 2008 Database

To track changes in your database you must have change data capture enabled. The change data capture object in CA ERwin Data Modeler provides the specifications for capturing changes to data stored in a table without creating triggers or modifying the schema of the table.

Use the options in the SQL Server Database Editor to enable change data capture for a database in a SQL Server 2008 physical model.

To enable change data capture for a SQL Server 2008 database

  1. Click Target - SQL Server, Databases on the Model menu.

    The SQL Server Database Editor opens.

  2. Select the database in the Navigation Grid for which you want to enable change data capture.
  3. Specify the True value in the Is Change Data Capture Enabled drop-down option in the Navigation Grid.
  4. Click the General tab and work with the following options:
    Change Tracking

    Specifies whether to enable or disable change tracking for the database.

    Auto Cleanup

    Specifies whether to enable automatic removal of the change tracking information from the database. An ENABLE value specifies that change tracking information is automatically removed from the database after the specified retention period. A DISABLE value specifies that change tracking information is not removed from the database.

    Change Retention Period

    Specifies the minimum timeframe for retention of change tracking information. Enter a number that corresponds to the timeframe you must select in the Change Retention Period Type drop-down. For example, you can enter 10 in this field, and then specify whether this is minutes, hours, or days in Change Retention Period Type.

    Note: Change tracking information is removed only if the Auto Cleanup option is enabled.

    Change Retention Period Type

    Lets you specify the timeframe that corresponds to the numerical value you entered in the Change Retention Period field. Make a selection from the drop-down.

  5. Click Close.

    Change data capture is enabled and defined and the SQL Server Database Editor closes.