1.select具体字段
[root@host135 script]# more sqlserver2mysql02.json
{
"job": {
"content": [
{
"reader": {
"name": "sqlserverreader",
"parameter": {
"connection": [
{
"jdbcUrl": ["jdbc:sqlserver://192.168.2.84:1433;DatabaseName=db_test"],
"querySql": ["select id,platform,site_id from tb_test"]
}
],
"password": "pub@123456",
"username": "sa",
"column": ["*"]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"column": [
"id",
"platform",
"site_id"
],
"connection": [
{
"jdbcUrl": "jdbc:mysql://192.168.1.135:3306/db_hxl",
"table": ["tb_test"]
}
],
"password": "mysql",
"preSql": ["truncate table tb_test"],
"session": [],
"username": "root",
"writeMode": "insert"
}
}
}
],
"setting": {
"speed": {
"channel": "5"
}
}
}
}