CDC

CDC Purge

The CDC Purge menu item can be used to delete the data of change records other than the old data based on user input about the number of days of data that should be deleted and the maximum number of records that should be deleted per batch. To delete change data records, from CDC → CDC Purge, select the source database and the number of days of data that you want to retain. Specify the number of records to be processed per batch and click Submit. If you set the Number of days to 0, all records are purged regardless of the date. If you set the Max Processed field to 0, all records are purged in one batch.

CDC Count

The CDC Count menu item can be used to get the actual record count of the CDC change tracking table based on whether the records are processed or not processed. This can be done by selecting the database from Select Database and then selecting Operation Type as Applied/Not Applied from CDC → CDC Count.

Users can get the processed records by selecting Applied from the Operation Type drop down. To get the list of records that are not processed, used should select Not Applied from the Operation Type drop down. By setting the Max Processed field, you can control the maximum number of records that are processed by the CDC Count function. If you set the Max Processed to 0, all records are counted in one batch.