Previous Topic: Define a Table in SQL Server 2008Next Topic: Define Change Data Capture Properties

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

Define Change Data Capture Settings for a SQL Server 2008 Table

If your database is enabled for change data capture, then it can track database changes. 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. A table can have up to two specifications for data capture.

Use the ChangeDataCapture tab in the SQL Server Table Editor to define change data capture settings in a SQL Server 2008 physical model.

Note: Tables should be defined to a database schema to generate change data capture information during forward engineering.

To define change data capture for a SQL Server 2008 table

  1. Click Tables on the Model menu.

    The SQL Server Table Editor opens.

  2. Select the table in the Navigation Grid for which you want to define change data capture settings.

    Note: Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

  3. Click the ChangeDataCapture tab and work with the following options:
    Name

    Specifies the name of the change data capture object. You can change the name of the change data capture object in this field.

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new change data capture object, or click the Change Data Capture Editor Button button to open the SQL Server Change Data Capture Editor to manage change data capture object properties.

    Database Role

    Specifies the database role in the corresponding database that is enabled for change data capture. Select the database role from the drop-down list.

  4. Click Close.

    Change data capture settings are defined and the SQL Server Table Editor closes.

More information:

Enable Change Data Capture for a SQL Server 2008 Database

Define Change Data Capture Properties