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

Define Change Data Capture Settings for a SQL Server Table

If your database is enabled for change data capture, then it can track database changes. The change data capture object in 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 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 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 on the toolbar to create a new change data capture object, or click the 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.