FLINK SQL JDBC同步

1.可以作为数据同步工具使用
1.FLINK jdbc连接器可读可写，实现jdbc数据同步
CREATE TABLE ft(
id INT,
name varchar(50),
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:sqlserver://x.x.x.x:1433;DatabaseName=dw_bak',
'table-name' = 'ft',
'username' = 'sa',
'password' = '123456',
'driver' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
);

CREATE TABLE ftin(
id INT,
name varchar(50),
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = 'jdbc:sqlserver://x.x.x.x:1433;DatabaseName=sink_dw',
'table-name' = 'ft',
'username' = 'sa',
'password' = '123456',
'driver' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
);

insert into ftin
select * from ft;