sqlserver开启cdc

数据源开启cdc


SELECT is_cdc_enabled FROM sys.databases WHERE NAME = 'keen'

-- 对表开启
use 库名;
EXEC sys.sp_cdc_enable_table
     @source_schema = N'test',
     @source_name   = N'test_other_type',
     @role_name     = NULL,
     @filegroup_name = NULL,
     @supports_net_changes = 0
GO

SELECT s.name AS Schema_Name, tb.name AS Table_Name
     , tb.object_id, tb.type, tb.type_desc, tb.is_tracked_by_cdc
FROM sys.tables tb
         INNER JOIN sys.schemas s on s.schema_id = tb.schema_id
WHERE tb.is_tracked_by_cdc = 1