https://www.cnblogs.com/xuanqust/p/11106679.html
sqlserver开启cdc– Create the test database
CREATE DATAbase ReportServerTempDB;
GO
USE ReportServerTempDB;
EXEC sys.sp_cdc_enable_db;
– Create some customers …
CREATE TABLE customers (
id INTEGER IDENTITY(1001,1) NOT NULL PRIMARY KEY,
first_name VARCHAr(255) NOT NULL,
last_name VARCHAr(255) NOT NULL,
email VARCHAr(255) NOT NULL UNIQUE
);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘Sally’,‘Thomas’,‘sally.thomas@acme.com’);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘George’,‘Bailey’,‘gbailey@foobar.com’);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘Edward’,‘Walker’,‘ed@walker.com’);
INSERT INTO customers(first_name,last_name,email)
VALUES (‘Anne’,‘Kretchmar’,‘annek@noanswer.
