Previous Topic: Define Change Data Capture Settings for a SQL Server 2008 TableNext Topic: Define SQL Server 2008 Table Column 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 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 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.

The SQL Server Change Data Capture Editor is used to define the properties of change data capture objects in a SQL Server 2008 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 New icon in property editors to create a new object 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.