Sql Server cdc变更捕获使用

-----启用CDC：

USE cctest  --要启用CDC的数据库
   GO
  EXECUTE sys.sp_cdc_enable_db;
  GO

-----关闭目标表的cdc

EXECUTE sys .sp_cdc_DISable_table @source_schema = N'dbo', @source_name = N'要关闭cdc的表名', @capture_instance = 'ALL' ;

-----开启目标表的cdc

EXECUTE sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'要开启cdc的表名',@role_name =NULL, @capture_instance = DEFAULT;

-----查看哪些表开启了CDC

SELECT name ,
is_tracked_by_cdc ,
CASE WHEN is_tracked_by_cdc = 0 THEN 'CDC 功能禁用'
ELSE 'CDC 功能启用'
END 描述
FROM sys .tables
WHERE is_tracked_by_cdc= 1