1.备份表结构:
Navicat先复制SqlServer表结构,然后再用复制,直接粘贴到mysql,这个是最快的表结构同步方法。
2.开始使用:
前面的步骤不介绍了,如何增量同步,直接传入时间格式即可
修改json文件
{
"job": {
"setting": {
"speed": {
"channel": 3,
"byte": 1048576
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "sqlserverreader",
"parameter": {
"username": "MLFmmKWBP27zxp5TlhEksw==",
"password": "123",
"connection": [
{
"jdbcUrl": [
"jdbc:sqlserver://192.168.1.137:1433;DatabaseName=test2"
],
"querySql": [
"select * from dbo.count_member_offer_last where count_date >= ${lastTime} and count_date < ${currentTime}"
]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "update",
"username": "/uw4SGBBO+/nvSlYoaGuCg==",
"password": "123",
"preSql": [
"truncate count_member_offer_last"
],
"column": [
"`id`",
"`count_date`",
"`user_name`",
"`product_counts`",
"`product_status_counts`",
],
"connection": [
{
"table": [
"count_member_offer_last"
],
"jdbcUrl": "jdbc:mysql://192.168.3.101:3306/test?serverTimezone=GMT%2B8&verifyServerCertificate=false&useSSL=false"
}
]
}
}
}
]
}
}
我这边有每天清空表的需要要么 “preSql”: [ “truncate table” ]是不需要写的。