CREATE DATABASE testdb;
USE testdb;

CREATE SCHEMA CDCTEST;

CREATE TABLE CDCTEST.CUSTOMER (
  "c_id" integer NOT NULL,
  "c_d_id" integer NOT NULL,
  "c_w_id" int NOT NULL,
  "c_first" varchar(16)  DEFAULT NULL,
  "c_middle" char(2)  DEFAULT NULL,
  "c_last" varchar(16)  DEFAULT NULL,
  "c_street_1" varchar(20)  DEFAULT NULL,
  "c_street_2" varchar(20)  DEFAULT NULL,
  "c_city" varchar(20)  DEFAULT NULL,
  "c_state" char(2)  DEFAULT NULL,
  "c_zip" char(9)  DEFAULT NULL,
  "c_phone" char(16)  DEFAULT NULL,
  "c_since" datetime2(6) DEFAULT NULL,
  "c_credit" char(2)  DEFAULT NULL,
  "c_credit_lim" decimal(12,2) DEFAULT NULL,
  "c_discount" decimal(4,4) DEFAULT NULL,
  "c_balance" decimal(12,2) DEFAULT NULL,
  "c_ytd_payment" decimal(12,2) DEFAULT NULL,
  "c_payment_cnt" int DEFAULT NULL,
  "c_delivery_cnt" int DEFAULT NULL,
  "c_data" varchar(500)  DEFAULT NULL,
  PRIMARY KEY ("c_w_id","c_d_id","c_id")
 
) ;

INSERT INTO  CDCTEST.CUSTOMER
("c_id",
"c_d_id",
"c_w_id",
"c_first",
"c_middle",
"c_last",
"c_street_1",
"c_street_2",
"c_city",
"c_state",
"c_zip",
"c_phone",
"c_since",
"c_credit",
"c_credit_lim",
"c_discount",
"c_balance",
"c_ytd_payment",
"c_payment_cnt",
"c_delivery_cnt",
"c_data")
VALUES
('1', '1', '1', 'YPMEqJQ5IEP', 'OE', 'JAMIE 58', 'wa0VoV7bqHSzD', 'KnccHddq9hQOIJ0C9', 'Dmj3vz6HARRt1FfLOm9w', '8J', '599511111', '9649048615610128', '2019-07-12 14:16:53.123456', 'GC', '50000.00', '0.0100', '-10.00', '10.00', '1', '0', '2uugupWLaZRZBlBxWvPiaiR0HaNotpnmysPu02MO9SLNYFsmlU52vEYKOVDtZVSJEgwpyyGv1GXbu1GYBkLpcVYGBBKELe8LDn4JlTELYgxSSSLw6fTlu9O7RY2XP940DdcOPcQRJNXBnnKUl2EK2AZn3dlhW04ki6Q55qkTYbQu35rE183RR4ObRlmB182LcPe0AP8eUECiPaXfprPUTBVcLb1yZK0GEVop3WEEMVG27k2epsRNpHt5iDOqo59yRrh04xt4mk9cKRemSYkKzihcxbZQaWpZiTtb9GZGHBKlNyCrod9HRq7Vsu6X7g1Avq1VKmkZEHbUYV1S9iFr16DgDy8UFPiRqq4lq5rFcDiPUIw0zuYdSnekMBNOWqJA'),
('2', '1', '1', 'abjLiHVtX7', 'OE', 'JAMIE 32', 'm8GZI5UurI7pbQn', 'Kc4X1KYH2e7r', '24vhA7CNiPVS4eO', 'MW', '470211111', '3097542740098740', '2019-07-12 14:16:53', 'GC', '50000.00', '0.4200', '1025.00', '10.00', '1', '0', '3cdfoAy1wdl8AjZhWuM6JsgJ1BLLkCd75VPjgnkO8IzbfUFs9tKcn0lhuUmlZavaQXyvOBReHJriG0kwRKoAJCXz7j3ypEao4Ukpt7vuzyvdHTl1CiMTr5Hp5yTdnbPv19zVowA09NhU8ZRm7LmXBthjm880NHcPSXXTcD6qN84wVLaDkjtI5oHqDaxwjAFDOA15ucC0XDiuH8U6U8whulQraAPMXOziCFC8k9xKyIoRO1wI437qTKdwuFoK9TqSAsHdp0xxRaa9wHnS6xRUkF6o7NtToaojOFT5hP31fsZTnMrGv1fwsMKZ2KfLFTg7fHG9mxhiBI17QqHAdSfUmcMqctJHOEa834dw5LNQkBEnh5s6DzISaJJazbMwzqIXfgjQD6oMopKeIBxccf1S2utAHqmawTGf79jzVcHb6z'),
('3', '1', '1', 'zUopfB4OpFQVj54t', 'OE', 'JAMIE 32', '8oq3O01Uc5o7HQCjO', 'CMfV4MJvVKastzjDcc', 'Jlfj9uZ2NgN', 'L5', '929911111', '3706237873872500', '2019-07-12 14:16:53', 'GC', '50000.00', '0.4400', '-10.00', '10.00', '1', '0', 'V5FFBJvCzs82Ft9Tc8TNUfty195nLEmr2YtxbLer7ZSpUJHpVpIHwpjV4txsJpOtALGVzuC7AhTtVvQuLp0dHvXFz2wSqf3IzAmaS0BI8J6afvZpLXKGzjueUOHRiRdDokoC3OZgmdqdkpYYnbGZfJJnA6RAp4ZQFNFdXWDnCM1yPbIjBQWxo3eg9kJCwFCM20VtuPvGnGP5EtlfNlnCxSkcf2d45xxYnHMUsngz6cAW946FZZR0UINWX0d6SSan1ntpFFIRIm1RKNuBH4lYiB3sCI0SW4Cj8wxiDij4xwZGWvomTnleF8yES4t3IIjhhnoKHziQD9rG6HGuAPjtbtcHDBkyjT8wVshbKt1ATgIWPjgd4pt1KSWodPyyXqLNTN7CRBdIizWaVS24WOqLSf2ik3UkZuK6MrDnB9Y7ALuIHDWaTAuuJUAWjXpQmar'),
('4', '1', '1', 'CsPuJqvoI1J', 'OE', 'JAMIE 32', 'c27rmEkoVqJYZ71Ggo', '0l3I3FMHcuC1NqB', 'S6CPNjNydqcNednml', 'hc', '611311111', '5505005826338725', '2019-07-12 14:16:53', 'GC', '50000.00', '0.3800', '-10.00', '10.00', '1', '0', '1qPxmch1cIN5tXnLD9sNlIB9Fkv7vRJdA7kVvDnCZRylJrNF8T6btvtcp0TFtd4jqmbKbbvLwLVn67oXUftpPb5CwykpkcLY5vpb7ldI1tgVFdSo0QIZ41HnO7ZqKjdC3HdHQKhjISr2qnzRQxo70TkEA7WuowteMMuXTKeGmBtpTiLW0MCEis5SxkdZb3RQ0PoXE0OjseU4x6VVZ05FscxBGYZYWr8MBhvfvX3jqj7WSUK7R4L05rspnDb5SgcNkZOL6ctu7jtZb2PT9KyWpbJtlJ9GrkXmVHBYicBRl1di0AycQDhNtuxXjAxkHgJZpD1QZzFIIO'),
('5', '1', '1', 'AEW2DG6sX7e', 'OE', 'JAMIE 32', 'AxXqoHD5toGJuKj', 'SiyQapU9kf', 'fse4IfX9UvKnr8fhFyQ', 'qX', '497911111', '2495984918559300', '2019-07-12 14:16:53', 'BC', '50000.00', '0.1700', '-10.00', '10.00', '1', '0', 'fRdmoMKxIKQQRdqV50tM2Who9xj9hLKHg7qeywVgFAUAJT7kKaKhGFPGsqvf5r0DZSwg1pEYxzTROUcE0Q6kQKyLlc6Ls3bZh27B0ZYFscr4RbqDrdNTFd9C90QmIpzXpf39AMn47vdG7sUAMk9kzkIu0LeSisDbWyOxJZaMiljaPADLQgIVpGswWJemCHxCHLCjmsJAG8DLEkqxwshCVvFAaBBlNQPLYOTdzetUEBjW9P0Ks8tLFtvbKvhbYbRitRGE0vMA3VxorVvDcXEj5mt7gND7VsVPbl6mQyeEarX74cEqWe33IHfh5TiaEluBGOKGdLnOzzfbAyStNYUEqc70QH8n9DZ78pXLoduwQIHibO0FHyg3Bx1gz6LbasPsK2g2fzPw05CYaiXedj89OFlRwqlcszv6pRUAVctXLw7gF9uQm130N4C09ArN4EbECaCPhEf8w5U'),
('6', '1', '1', 'ulBbR8TU7iQb99u', 'OE', 'JAMIE 32', 'R1Wflx5UA1oyENPab', 'j6hkkcwXdMqxIdvrJFe3', 'eIAGQlVXzQX8uUF', 'g8', '250111111', '3373213736026669', '2019-07-12 14:16:53', 'BC', '50000.00', '0.3800', '-10.00', '10.00', '1', '0', 'lUYWb2E2heTBCTOXbBTWlRjKWRjO3zHtB2eOXj5wUHIkbwiuWU9uPpjzqLBV71PcyNtINZlXHRM44xrHft8moxlTmNksSAPhAMOZ0lUPfC0Gspa5K9yWP8JmRxfvyxUnPKSGyvJeazi4mEkHeyBIXKz38OboCi43xslOz9DSlv1naYtWHBDaGbxprj44bkBIz4uNQBGSrSKU19pjyc7KzI0zijSDagXqTMUVVDqWkJefjC6RbD8WAi5d6kdguKkzWAen3wU9QxPnlJSGBaUk2aPxhffafFdaCM4GtT9KlUFja26R0CTwOzwc8GjSjKhVPUh848R2W9'),
('7', '1', '1', 'BIafFFyLsy0J', 'OE', 'JAMIE 32', 'BFVRJmhmjuWVy', 'k1OU6fa3dU0YlLpVRPsL', 'RrkryfXyDVZh7Z', 'rN', '699611111', '2450903023267766', '2019-07-12 14:16:53', 'GC', '50000.00', '0.3600', '-10.00', '10.00', '1', '0', 'Gs6WGvwr5S0tNQBsTKAIbow5stnevfKlATK4JIUwJfVM2hkVJnms5A6mqU3GOChkrtNbrHj3qWonFh9xpsGmqarb4L58U2uyuaBti8fzjzJNaKO3fCdCPBC5aIJzWTfepMWFIojUW1pIxyHe2TE7yldYdL3ZEuOemBdHr6F766JXF9VVWWwwjx2ZbXkMWS9f1QcJu7AiSQZTe2VJk0UyQerUsQcPgfR1Z0IGfYfyLrdOXOWIpQoCKpAlDxvMydAhSfxXGF7NkX17oQXuOQWzzMur6OOLZcUaj5i5AKPgKwmRt2dkkCXc721oaQd5uJgSoy5QZPhbF2mdJszExgjOPLjs1fiz7vpZvuDkeB01dYGdtettJlO7476oymGJVVG5vCC6jOnNVPxGKnc7KYAoacu6tRhpkDHSYnfHGN1NFgNBkSTXZkOdWa8h461vAU9sd2ppjQaoFijkGQjEi8rCAw1dZlS673YY9RRwm8amu0'),
('8', '1', '1', 'XwVhWChT4IoVi0v', 'OE', 'JAMIE 32', 'KdFUMTLgwP75Br', 'whvauesLLce', '6tLMB4JX66vE4', 'bX', '688411111', '3066490385028404', '2019-07-12 14:16:53', 'GC', '50000.00', '0.2400', '-10.00', '10.00', '1', '0', '6UaoGqTlQy6dghP2puMPwSfAm97jz4UyMxD9FTDetXPGhM0fKAuL4ki1lkVz5oS5Kvj83xCByNy2MGeguTYiQiHifbxSVsfG4A71f12LgFpWBzVEBBylcYZbfpiV1XQyzXqNjJpEfkX1O2Felahx2Pem4ukT0oQ5lgRBoytsOtfy7CZhf3sgkz7QCvuQJkOzViECc4uKVGjwTaoQBNDq2c7yIiDlkTBokczwJ9z30nTTCZtDsmgpvocMTQSG2SccqhYoYeh6vAphf41k0mspoTuBcLsz9HAzzs4U1pZuiMHkbqPMLkqxKyrCid6QzRqSTMBU9YeLnW3vTvE6EwYEq6VZfxUvXJxo178fa6IjlDVY4mDiIlvPd9YPcO2sUkA9UgPtvovmwDmk2S'),
('9', '1', '1', 'pbVTUJJ17', 'OE', 'JAMIE 32', 'xBtvtdOLUwq', '5hcqnvVCz2GE2Px7tSJw', 'mXEmGh5p60ldqEmAq', 'Hf', '894711111', '4092852185655237', '2019-07-12 14:16:53', 'BC', '50000.00', '0.2900', '3720.00', '10.00', '1', '0', '9 1 1 1 1 3,730.002019-11-04hOxeLh I0g70QcgZzjAya8S09GPGCnKojjoZopo6OgVYc9DXoh7hU6MGtXAlUmFP4TyTJFDtIqSRMkctyeRoxN861hBg915r9Avn9oYxOAW7TZqoLB7ZmlN1WUHJ21VfokYlaAfwST6uPrzrQLfKJpvNiKHuYZ1FROi8E5cnX8bFQWCm5GHNxkaePjqOoEHataG0Nb9ZY7UCKFcjxzuuMi2xrnEaaq9Y8pCZFsTtAHor3SrAnqFuduk5q3wGR0qZ0pywCeJoGVk8bULI8dsH0q39EQ7CKR2XTFGoYGUHirZhsH776NsP7QSb7bVnjhzIvKGWNIvQTeVxJUDknW6KKpy05qWLrXVd98jxWImodCW7uDJpBnGVk3R8dorUBBEBSnejubvQKHhTxq6BFi4RgKUeYrORLgn1wCiwG5f'),
('10', '1', '1', 'waEz5i5uDbmjiZ', 'OE', 'JAMIE 32', 'gTHsYIP7Yel', 'DltOIKCnAIZ70Lct5drO', 'jDFeY5LzC4ylYDObHs8', 'JK', '484711111', '1347174919698951', '2019-07-12 14:16:53', 'GC', '50000.00', '0.0100', '-10.00', '10.00', '1', '0', 'W6xny7pn3rlZ3AGYNYEpvwAaW5G5Cpl8No9QsYrDmLzTgD1uMAUV2nmR4q73b8RIDi5YydnJkzmbyUTbkG42QaQqKAcAIcrfJRv0RSjvtv5i6ORSGFlW8FQTKbeGzg0uXqy9lW2eRtNp5ppW7UaEvhcQlZU2rDAPnvDHA9aMBtv1MtrKj6eOJamLpHVGLq1g9wri1HV932bEDcvAqXZvPBBcBw5hnvE4Vr7RTdObVjCD9qgLAuobLQwrtTwrlGnQskRgrnw1TpfHAU8WZpFCpQLY3Y5bDddtY76lrUZ4g74XEqY1lxPciUrUAA6B0q68QM1LGfoI3c942mkEc0z4QUVnOrYwkAqDhk088jQrmOy');

-- ====
-- Enable Database for CDC template
-- ====
USE testdb

EXEC sys.sp_cdc_enable_db


USE testdb


EXEC sys.sp_cdc_enable_table
@source_schema = N'CDCTEST',
@source_name   = N'CUSTOMER',
@role_name 	   = NULL,
@supports_net_changes = 0


EXEC sys.sp_cdc_help_change_data_capture