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 Properties

Define Change Data Capture Properties

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 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.

The SQL Server Change Data Capture Editor is used to define the properties of change data capture objects in a SQL Server physical model.

To define change data capture properties

1. Click Tables on the Model menu.

   The SQL Server Table Editor opens.

2. Select the table in the Navigation Grid that contains the change data capture object that you want to define.

   Note: Click New on the toolbar to create a new table. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want.

3. Click the ChangeDataCapture tab and then click the Change Data Capture Editor button on the toolbar.

   The SQL Server Change Data Capture Editor opens.

4. Click the General tab and work with the following options:

   Is Net Change Supported

   Specifies whether net change queries are supported.

   Is Partition Switch Allowed

   Specifies whether partition switching is allowed on the table.

   Index

   Specifies the index present on the table.

   Filegroup

   Specifies the filegroup of the database in which the table is located.

   Columns

   Lets you specify the columns in the source table from which to capture data.

5. Click Close.

   Change data capture properties are defined, the SQL Server Change Data Capture Editor closes, and you are returned to the SQL Server Table Editor.

6. Click Close.

   The SQL Server Table Editor closes.