SQL Server Migration to Kafka

-- Specify the database name
use dbname
-- Enable CDC feature
exec sys.sp_cdc_enable_db
-- Check if the CDC is enabled for the dbname database, a return value of 1 means it is enabled
select is_cdc_enabled from sys.databases where name = "dbname";
-- Enable CDC for the dbo.tablename table
exec sys.sp_cdc_enable_table @source_schema = 'dbo',@source_name = 'tablename',@role_name = null;
-- Check if the CDC is enabled for the dbo.tablename table, a return value of 1 means it is enabled
select is_tracked_by_cdc from sys.tables where name = 'tablename'
-- Modify the CDC data retention time, at least set to 1440 minutes (1 day) or more, recommended 14400 minutes (7 days).
EXECUTE sys.sp_cdc_change_job @job_type = N'cleanup', @retention = 14400;