tencent cloud

Feedback

Setting Change Data Capture (CDC)

Last updated: 2022-03-29 15:22:24

    Change data capture (CDC) is used to capture insertions, updates, and deletion applied to SQL Server tables and provide the details of these changes in a convenient relational format.

    The change table used for CDC contains the columns of the column structure of the source table tracked by the image, as well as the metadata required for understanding the changes that have occurred. After CDC is enabled for a table, all DML and DDL operations on it will be recorded, which helps track changes to it.

    Enabling/Disabling CDC for One Database

    1. Log in to the TencentDB for SQL Server console. In the instance list, click an instance ID or Manage in the Operation column to access the instance management page.
    2. On the instance management page, select the Database Management tab, select the row of the target database, and click Other > Enable/Disable CDC in the Operation column.
    3. The pop-up window displays the name and current CDC status of the database. After enabling or disabling CDC, click OK.


      You can view the task progress of enabling or disabling CDC through Current Task in the top-right corner of the Database Management tab.

    Batch Enabling/Disabling CDC for Multiple Databases

    1. Log in to the TencentDB for SQL Server console. In the instance list, click an instance ID to access the instance management page.
    2. On the instance management page, select the Database Management tab, select the rows of the target databases, and click Batch Management > Batch Enable/Disable CDC at the top of the list.
    3. The pop-up window displays the names and current CDC status of the selected databases. After enabling or disabling CDC, click OK.

      You can view the task progress of enabling or disabling CDC through Current Task in the top-right corner of the Database Management tab.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support