debezium+kafka实现sqlserver数据同步

1. 需要准备的软件环境

jdk1.8
zookeeper3.4.14
kafka2.12-2.2.0
debezium-connector-sqlserver
confluent-kafka-connect-jdbc 

2. 开启sqlserver数据库CDC功能

开启数据库CDC功能

USE CDCTEST; 
GO
EXEC sys.sp_cdc_enable_db

查询哪些数据库启用了CDC功能

select * from sys.databases where is_cdc_enabled = 1

开启数据库表CDC功能

EXEC sys.sp_cdc_enable_table 
@source_schema = 'dbo',
@source_name = 'testUser',
@supports_net_changes = 1, 
@role_name = null;

查看表是否启用了CDC

select name, is_tracked_by_cdc from sys.tables where object_id = OBJECT_ID('dbo.testUser');

关闭表CDC功能

EXEC sys.sp_cdc_disable_table 
@source_schema = 'dbo', 
@source_name = 'testUser', 
@capture_instance = 'all';

关闭数据库CDC功能

EXEC sys.sp_cdc_disable_db;

CDC功能开启后，数据库会生成多张系统表，其中dbo_testUser_CT会记