sqlserver的flink-cdc-sql
官网误导问题
官网
我根据官网sql发现缺少了schema-name,可以去对比一下
官网的sql
CREATE TABLE orders (
id INT,
order_date DATE,
purchaser INT,
quantity INT,
product_id INT,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'sqlserver-cdc',
'hostname' = 'localhost',
'port' = '1433',
'username' = 'sa',
'password' = 'XXXX',
'database-name' = 'inventory',
'table-name' = 'dob.orders'
);
我的sqlserver2Mysql-cdc-sql
记得要分割啊!!!
CREATE TABLE source_table (
id STRING,
name STRING,
age STRING,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'sqlserver-cdc',
'hostname' = '192.168.1.90',
'port' = '1433',
'username' = 'sa',
'password' = 'XXXXX',
'database-name' = 'TestDataworks',
'table-name' = 't_wx_source',
'schema-name'='dbo'
);
CREATE TABLE target_table (
id String Not Null,
name String,
age String,
PRIMARY KEY(id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:mysql://192.168.1.91:3306/test',
'table-name' = 't_wx_target_1',
'username' = 'root',
'password' = 'XXXXXX',
'driver' = 'com.mysql.cj.jdbc.Driver'
);
INSERT INTO target_table SELECT id, name, age FROM source_table;