【开发问题】flink-cdc-sqlserver-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;