{"id":46963,"date":"2023-03-14T03:01:03","date_gmt":"2023-03-11T21:32:31","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/"},"modified":"2024-04-29T18:46:46","modified_gmt":"2024-04-29T10:46:46","slug":"%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/","title":{"rendered":"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e"},"content":{"rendered":"<h1>\u9996\u5148<\/h1>\n<p>\u6211\u4e4b\u524d\u5199\u8fc7\u4e00\u7bc7\u5173\u4e8e\u5982\u4f55\u4f7f\u7528Debezium\u83b7\u53d6MySQL\u66f4\u6539\u6570\u636e\u7684\u6587\u7ae0\u3002\u63a5\u4e0b\u6765\u6211\u4eec\u6765\u4e86\u89e3\u4e00\u4e0b\u5982\u4f55\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e\u7684\u65b9\u6cd5\u3002<\/p>\n<p>\u6211\u53c2\u8003\u4e86\u4ee5\u4e0b\u4e24\u4e2a\u94fe\u63a5\uff1a<br \/>\n&#8211; [https:\/\/github.com\/debezium\/debezium-examples\/tree\/master\/tutorial#using-sql-server](https:\/\/github.com\/debezium\/debezium-examples\/tree\/master\/tutorial#using-sql-server)<br \/>\n&#8211; [https:\/\/debezium.io\/documentation\/reference\/0.9\/connectors\/sqlserver.html](https:\/\/debezium.io\/documentation\/reference\/0.9\/connectors\/sqlserver.html)<\/p>\n<h4>\u6267\u884c\u73af\u5883<\/h4>\n<p>AWS EC2 Linux2<br \/>\n\u9700\u8981\u4e8b\u5148\u5b89\u88c5 Docker\u3002<\/p>\n<h1>\u5b89\u88c5<\/h1>\n<p>\u7531\u4e8e\u672c\u6b21\u63d0\u4f9b\u4e86\u6587\u4ef6\uff0c\u6240\u4ee5\u9996\u5148\u9700\u8981\u8fdb\u884c\u6587\u4ef6\u4e0b\u8f7d\u3002<\/p>\n<pre class=\"post-pre\"><code>curl -O https:\/\/raw.githubusercontent.com\/debezium\/debezium-examples\/master\/tutorial\/register-sqlserver.json\r\ncurl -O https:\/\/raw.githubusercontent.com\/debezium\/debezium-examples\/master\/tutorial\/docker-compose-sqlserver.yaml\r\ncurl -O https:\/\/raw.githubusercontent.com\/debezium\/debezium-examples\/master\/tutorial\/debezium-sqlserver-init\/inventory.sql\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">register-sqlserver.json\uff1aSQL Server\u306e\u30b3\u30cd\u30af\u30bf\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8a18\u8f09\u3059\u308b\u30d5\u30a1\u30a4\u30eb<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">docker-compose-sqlserver.yaml\uff1azookeeper\u3001kafka\u3001SQL Server\u3001connect\u306e\u30b3\u30f3\u30c6\u30ca\u3092\u8d77\u52d5\u3059\u308b\u305f\u3081\u306e\u30d5\u30a1\u30a4\u30eb<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">debezium-sqlserver-init\/inventory.sql\uff1aSQL Server\u5185\u306bDB\u3001\u30c6\u30fc\u30d6\u30eb\u3001\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u30fb\u767b\u9332\u3059\u308b\u305f\u3081\u306e\u30d5\u30a1\u30a4\u30eb<\/ul>\n<h4>\u542f\u52a8\u6240\u6709\u5bb9\u5668<\/h4>\n<p>\u542f\u52a8Zookeeper\u3001Kafka\u3001SQL Server\u548cConnect\u5bb9\u5668\u3002<\/p>\n<pre class=\"post-pre\"><code>export DEBEZIUM_VERSION=0.9\r\ndocker-compose -f docker-compose-sqlserver.yaml up\r\n<\/code><\/pre>\n<p>\u5728Docker ps\u4e2d\u786e\u8ba4\u5df2\u542f\u52a8\u3002<\/p>\n<pre class=\"post-pre\"><code>CONTAINER ID        IMAGE                                        COMMAND                  CREATED             STATUS              PORTS                                                                                        NAMES\r\n899bba830789        debezium\/connect:0.9                         \"\/docker-entrypoint.\u2026\"   2 minutes ago       Up 2 minutes        8778\/tcp, 9092\/tcp, 0.0.0.0:8083-&gt;8083\/tcp, 9779\/tcp                                         ec2-user_connect_1\r\n4fabee9ff69e        debezium\/kafka:0.9                           \"\/docker-entrypoint.\u2026\"   2 minutes ago       Up 2 minutes        8778\/tcp, 9779\/tcp, 0.0.0.0:9092-&gt;9092\/tcp                                                   ec2-user_kafka_1\r\n73765146588s        debezium\/zookeeper:0.9                       \"\/docker-entrypoint.\u2026\"   2 minutes ago       Up 2 minutes        0.0.0.0:2181-&gt;2181\/tcp, 0.0.0.0:2888-&gt;2888\/tcp, 8778\/tcp, 0.0.0.0:3888-&gt;3888\/tcp, 9779\/tcp   ec2-user_zookeeper_1\r\ncf0b6e715693        microsoft\/mssql-server-linux:2017-CU9-GDR2   \"\/opt\/mssql\/bin\/sqls\u2026\"   2 minutes ago       Up 2 minutes        0.0.0.0:1433-&gt;1433\/tcp                                                                       ec2-user_sqlserver_1\r\n<\/code><\/pre>\n<h4>\u5c06DB\u3001\u8868\u548c\u6570\u636e\u6ce8\u518c\u5230SQL Server\u4e2d\u3002<\/h4>\n<pre class=\"post-pre\"><code>cat inventory.sql | docker exec -i ec2-user_sqlserver_1 bash -c '\/opt\/mssql-tools\/bin\/sqlcmd -U sa -P $SA_PASSWORD'\r\n<\/code><\/pre>\n<p>\u60a8\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u547d\u4ee4\u786e\u8ba4\u6570\u636e\u5df2\u7ecf\u63d2\u5165\u6210\u529f\u3002<\/p>\n<pre class=\"post-pre\"><code>docker exec -i ec2-user_sqlserver_1 bash -c '\/opt\/mssql-tools\/bin\/sqlcmd -U sa -P $SA_PASSWORD -q \"use testDB; select * from customers;\"'\r\n<\/code><\/pre>\n<h4>\u914d\u7f6e SQL Server \u8fde\u63a5\u5668<\/h4>\n<pre class=\"post-pre\"><code>curl -i -X POST -H \"Accept:application\/json\" -H  \"Content-Type:application\/json\" http:\/\/localhost:8083\/connectors\/ -d @register-sqlserver.json\r\n<\/code><\/pre>\n<p>register-sqlserver.json\u6587\u4ef6\u5177\u6709\u4ee5\u4e0b\u7ed3\u6784\u3002<\/p>\n<pre class=\"post-pre\"><code>{\r\n  \"name\": \"inventory-connector\",  (1)\r\n  \"config\": {\r\n    \"connector.class\": \"io.debezium.connector.sqlserver.SqlServerConnector\", (2)\r\n    \"database.hostname\": \"192.168.99.100\", (3)\r\n    \"database.port\": \"1433\", (4)\r\n    \"database.user\": \"sa\", (5)\r\n    \"database.password\": \"Password!\", (6)\r\n    \"database.dbname\": \"testDB\", (7)\r\n    \"database.server.name\": \"fullfillment\", (8)\r\n    \"table.whitelist\": \"dbo.customers\", (9)\r\n    \"database.history.kafka.bootstrap.servers\": \"kafka:9092\", (10)\r\n    \"database.history.kafka.topic\": \"dbhistory.fullfillment\" (11)\r\n  }\r\n}\r\n<\/code><\/pre>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(1) Kafka Connect\u30b5\u30fc\u30d3\u30b9\u306b\u767b\u9332\u3059\u308b\u3068\u304d\u306e\u30b3\u30cd\u30af\u30bf\u540d\u79f0\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(2) SQL Server\u30b3\u30cd\u30af\u30bf\u30af\u30e9\u30b9\u540d\u79f0\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(3) SQL Server\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u30a2\u30c9\u30ec\u30b9\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(4) SQL Server\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u30dd\u30fc\u30c8\u756a\u53f7\uff081433\uff09\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(5) SQL Server\u30e6\u30fc\u30b6\u30fc\u540d\u79f0\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(6) SQL Server\u30e6\u30fc\u30b6\u30fc\u30d1\u30b9\u30ef\u30fc\u30c9\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(7) \u5909\u66f4\u3092\u30ad\u30e3\u30d7\u30c1\u30e3\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u79f0\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(8) SQL Server\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\/\u30af\u30e9\u30b9\u30bf\u30fc\u306e\u8ad6\u7406\u540d\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(9) Debezium\u304c\u30ad\u30e3\u30d7\u30c1\u30e3\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5909\u66f4\u3092\u542b\u3080\u3059\u3079\u3066\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30ea\u30b9\u30c8<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">(10) \u30b3\u30cd\u30af\u30bf\u30fc\u304c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5c65\u6b74\u30c8\u30d4\u30c3\u30af\u3078\u306eDDL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u306e\u66f8\u304d\u8fbc\u307f\u304a\u3088\u3073\u56de\u5fa9\u306b\u4f7f\u7528\u3059\u308bKafka\u30d6\u30ed\u30fc\u30ab\u30fc\u30ea\u30b9\u30c8\u3002<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">(11) \u30b3\u30cd\u30af\u30bf\u30fc\u304cDDL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f5c\u6210\u304a\u3088\u3073\u30ea\u30ab\u30d0\u30ea\u30fc\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5c65\u6b74\u30c8\u30d4\u30c3\u30af\u306e\u540d\u524d\u3002<\/ul>\n<h4>\u8bf7\u53c2\u8003\u4e0b\u5217\u8d44\u6599\u3002<\/h4>\n<p>\u5b89\u88c5\u5df2\u7ecf\u5b8c\u6210\u3002<\/p>\n<h1>\u83b7\u53d6\u53d8\u66f4\u6d88\u606f<\/h1>\n<p>\u6211\u4eec\u5c06\u5c1d\u8bd5\u4ee5\u5b9e\u9645\u7684JSON\u683c\u5f0f\u6355\u6349\u66f4\u6539\u3002<\/p>\n<pre class=\"post-pre\"><code>docker-compose -f docker-compose-sqlserver.yaml exec kafka \/kafka\/bin\/kafka-console-consumer.sh \\\r\n    --bootstrap-server kafka:9092 \\\r\n    --from-beginning \\\r\n    --property print.key=true \\\r\n    --topic server1.dbo.customers\r\n<\/code><\/pre>\n<p>\u5ba2\u6237\u6570\u636e\u5df2\u7ecf\u6210\u529f\u63d2\u5165\u5230customers\u8868\u4e2d\uff0c\u5e76\u4ee5JSON\u683c\u5f0f\u663e\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code>{\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Key\"},\"payload\":{\"id\":1001}}                                                                            {\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"before\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"after\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"string\",\"optional\":true,\"field\":\"version\"},{\"type\":\"string\",\"optional\":true,\"field\":\"connector\"},{\"type\":\"string\",\"optional\":false,\"field\":\"name\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"},{\"type\":\"string\",\"optional\":true,\"field\":\"change_lsn\"},{\"type\":\"string\",\"optional\":true,\"field\":\"commit_lsn\"},{\"type\":\"boolean\",\"optional\":true,\"field\":\"snapshot\"}],\"optional\":false,\"name\":\"io.debezium.connector.sqlserver.Source\",\"field\":\"source\"},{\"type\":\"string\",\"optional\":false,\"field\":\"op\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Envelope\"},\"payload\":{\"before\":null,\"after\":{\"id\":1001,\"first_name\":\"Sally\",\"last_name\":\"Thomas\",\"email\":\"sally.thomas@acme.com\"},\"source\":{\"version\":\"0.9.5.Final\",\"connector\":\"sqlserver\",\"name\":\"server1\",\"ts_ms\":1569814118560,\"change_lsn\":null,\"commit_lsn\":\"00000027:00000078:0001\",\"snapshot\":true},\"op\":\"r\",\"ts_ms\":1569814118560}}\r\n{\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Key\"},\"payload\":{\"id\":1002}}                                                                            {\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"before\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"after\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"string\",\"optional\":true,\"field\":\"version\"},{\"type\":\"string\",\"optional\":true,\"field\":\"connector\"},{\"type\":\"string\",\"optional\":false,\"field\":\"name\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"},{\"type\":\"string\",\"optional\":true,\"field\":\"change_lsn\"},{\"type\":\"string\",\"optional\":true,\"field\":\"commit_lsn\"},{\"type\":\"boolean\",\"optional\":true,\"field\":\"snapshot\"}],\"optional\":false,\"name\":\"io.debezium.connector.sqlserver.Source\",\"field\":\"source\"},{\"type\":\"string\",\"optional\":false,\"field\":\"op\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Envelope\"},\"payload\":{\"before\":null,\"after\":{\"id\":1002,\"first_name\":\"George\",\"last_name\":\"Bailey\",\"email\":\"gbailey@foobar.com\"},\"source\":{\"version\":\"0.9.5.Final\",\"connector\":\"sqlserver\",\"name\":\"server1\",\"ts_ms\":1569814118561,\"change_lsn\":null,\"commit_lsn\":\"00000027:00000078:0001\",\"snapshot\":true},\"op\":\"r\",\"ts_ms\":1569814118561}}\r\n{\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Key\"},\"payload\":{\"id\":1003}}                                                                            {\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"before\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"after\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"string\",\"optional\":true,\"field\":\"version\"},{\"type\":\"string\",\"optional\":true,\"field\":\"connector\"},{\"type\":\"string\",\"optional\":false,\"field\":\"name\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"},{\"type\":\"string\",\"optional\":true,\"field\":\"change_lsn\"},{\"type\":\"string\",\"optional\":true,\"field\":\"commit_lsn\"},{\"type\":\"boolean\",\"optional\":true,\"field\":\"snapshot\"}],\"optional\":false,\"name\":\"io.debezium.connector.sqlserver.Source\",\"field\":\"source\"},{\"type\":\"string\",\"optional\":false,\"field\":\"op\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Envelope\"},\"payload\":{\"before\":null,\"after\":{\"id\":1003,\"first_name\":\"Edward\",\"last_name\":\"Walker\",\"email\":\"ed@walker.com\"},\"source\":{\"version\":\"0.9.5.Final\",\"connector\":\"sqlserver\",\"name\":\"server1\",\"ts_ms\":1569814118561,\"change_lsn\":null,\"commit_lsn\":\"00000027:00000078:0001\",\"snapshot\":true},\"op\":\"r\",\"ts_ms\":1569814118561}}\r\n{\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Key\"},\"payload\":{\"id\":1004}}                                                                            {\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"before\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"after\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"string\",\"optional\":true,\"field\":\"version\"},{\"type\":\"string\",\"optional\":true,\"field\":\"connector\"},{\"type\":\"string\",\"optional\":false,\"field\":\"name\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"},{\"type\":\"string\",\"optional\":true,\"field\":\"change_lsn\"},{\"type\":\"string\",\"optional\":true,\"field\":\"commit_lsn\"},{\"type\":\"boolean\",\"optional\":true,\"field\":\"snapshot\"}],\"optional\":false,\"name\":\"io.debezium.connector.sqlserver.Source\",\"field\":\"source\"},{\"type\":\"string\",\"optional\":false,\"field\":\"op\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Envelope\"},\"payload\":{\"before\":null,\"after\":{\"id\":1004,\"first_name\":\"Anne\",\"last_name\":\"Kretchmar\",\"email\":\"annek@noanswer.org\"},\"source\":{\"version\":\"0.9.5.Final\",\"connector\":\"sqlserver\",\"name\":\"server1\",\"ts_ms\":1569814118561,\"change_lsn\":null,\"commit_lsn\":\"00000027:00000078:0001\",\"snapshot\":true},\"op\":\"r\",\"ts_ms\":1569814118561}}\r\n<\/code><\/pre>\n<p>\u53e6\u5916\uff0c\u6211\u5011\u5c07\u5c0d\u9867\u5ba2\u9032\u884c\u66f4\u65b0\u3002<br \/>\n\u5c07 id=1004 \u7684\u9867\u5ba2\u7684 first_name \u66f4\u6539\u70ba\u300cAnne\u2192123\u300d\u3002<\/p>\n<pre class=\"post-pre\"><code>docker exec -i ec2-user_sqlserver_1 bash -c '\/opt\/mssql-tools\/bin\/sqlcmd -U sa -P $SA_PASSWORD -q \"use testDB; update customers set first_name = 123 where id=1004;\"'\r\n<\/code><\/pre>\n<p>\u66f4\u6539\u5df2\u6355\u6349\u3002<\/p>\n<pre class=\"post-pre\"><code>{\"schema\":{\"type\":\"struct\",\"fields\":[{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"before\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"int32\",\"optional\":false,\"field\":\"id\"},{\"type\":\"string\",\"optional\":false,\"field\":\"first_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"last_name\"},{\"type\":\"string\",\"optional\":false,\"field\":\"email\"}],\"optional\":true,\"name\":\"server1.dbo.customers.Value\",\"field\":\"after\"},{\"type\":\"struct\",\"fields\":[{\"type\":\"string\",\"optional\":true,\"field\":\"version\"},{\"type\":\"string\",\"optional\":true,\"field\":\"connector\"},{\"type\":\"string\",\"optional\":false,\"field\":\"name\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"},{\"type\":\"string\",\"optional\":true,\"field\":\"change_lsn\"},{\"type\":\"string\",\"optional\":true,\"field\":\"commit_lsn\"},{\"type\":\"boolean\",\"optional\":true,\"field\":\"snapshot\"}],\"optional\":false,\"name\":\"io.debezium.connector.sqlserver.Source\",\"field\":\"source\"},{\"type\":\"string\",\"optional\":false,\"field\":\"op\"},{\"type\":\"int64\",\"optional\":true,\"field\":\"ts_ms\"}],\"optional\":false,\"name\":\"server1.dbo.customers.Envelope\"},\"payload\":{\"before\":{\"id\":1004,\"first_name\":\"Anne\",\"last_name\":\"Kretchmar\",\"email\":\"annek@noanswer.org\"},\"after\":{\"id\":1004,\"first_name\":\"123\",\"last_name\":\"Kretchmar\",\"email\":\"annek@noanswer.org\"},\"source\":{\"version\":\"0.9.5.Final\",\"connector\":\"sqlserver\",\"name\":\"server1\",\"ts_ms\":1569825287100,\"change_lsn\":\"00000028:00003640:0002\",\"commit_lsn\":\"00000028:00003640:0003\",\"snapshot\":false},\"op\":\"u\",\"ts_ms\":1569825292094}}\r\n<\/code><\/pre>\n<p>\u62bd\u53d6\u66f4\u6539\u90e8\u5206\u3002\u6211\u53d1\u73b0\u540d\u5b57\u53d1\u751f\u4e86\u53d8\u5316\u3002<\/p>\n<pre class=\"post-pre\"><code>    \"payload\": {\r\n        \"before\": {\r\n            \"id\": 1004,\r\n            \"first_name\": \"Anne\",\r\n            \"last_name\": \"Kretchmar\",\r\n            \"email\": \"annek@noanswer.org\"\r\n        },\r\n        \"after\": {\r\n            \"id\": 1004,\r\n            \"first_name\": \"123\",\r\n            \"last_name\": \"Kretchmar\",\r\n            \"email\": \"annek@noanswer.org\"\r\n        },\r\n<\/code><\/pre>\n<h1>\u6700\u540e<\/h1>\n<p>\u7531\u4e8e\u786e\u8ba4\u5b8c\u6210\uff0c\u5c06\u5220\u9664\u5bb9\u5668\u3002<\/p>\n<pre class=\"post-pre\"><code>docker-compose -f docker-compose-sqlserver.yaml down\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148 \u6211\u4e4b\u524d\u5199\u8fc7\u4e00\u7bc7\u5173\u4e8e\u5982\u4f55\u4f7f\u7528Debezium\u83b7\u53d6MySQL\u66f4\u6539\u6570\u636e\u7684\u6587\u7ae0\u3002\u63a5\u4e0b\u6765\u6211\u4eec\u6765\u4e86\u89e3\u4e00\u4e0b\u5982\u4f55\u4f7f\u7528De [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-46963","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528debezium\u83b7\u53d6sql-server\u7684\u66f4\u6539\u6570\u636e\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u6211\u4e4b\u524d\u5199\u8fc7\u4e00\u7bc7\u5173\u4e8e\u5982\u4f55\u4f7f\u7528Debezium\u83b7\u53d6MySQL\u66f4\u6539\u6570\u636e\u7684\u6587\u7ae0\u3002\u63a5\u4e0b\u6765\u6211\u4eec\u6765\u4e86\u89e3\u4e00\u4e0b\u5982\u4f55\u4f7f\u7528De [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528debezium\u83b7\u53d6sql-server\u7684\u66f4\u6539\u6570\u636e\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-11T21:32:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T10:46:46+00:00\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/\",\"name\":\"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-03-11T21:32:31+00:00\",\"dateModified\":\"2024-04-29T10:46:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528debezium\u83b7\u53d6sql-server\u7684\u66f4\u6539\u6570\u636e\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e","og_description":"\u9996\u5148 \u6211\u4e4b\u524d\u5199\u8fc7\u4e00\u7bc7\u5173\u4e8e\u5982\u4f55\u4f7f\u7528Debezium\u83b7\u53d6MySQL\u66f4\u6539\u6570\u636e\u7684\u6587\u7ae0\u3002\u63a5\u4e0b\u6765\u6211\u4eec\u6765\u4e86\u89e3\u4e00\u4e0b\u5982\u4f55\u4f7f\u7528De [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528debezium\u83b7\u53d6sql-server\u7684\u66f4\u6539\u6570\u636e\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-03-11T21:32:31+00:00","article_modified_time":"2024-04-29T10:46:46+00:00","author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/","name":"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-03-11T21:32:31+00:00","dateModified":"2024-04-29T10:46:46+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Debezium\u83b7\u53d6SQL Server\u7684\u66f4\u6539\u6570\u636e"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8debezium%e8%8e%b7%e5%8f%96sql-server%e7%9a%84%e6%9b%b4%e6%94%b9%e6%95%b0%e6%8d%ae\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/46963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=46963"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/46963\/revisions"}],"predecessor-version":[{"id":86995,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/46963\/revisions\/86995"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=46963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=46963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=46963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}