准备postgres数据库
准备mysql数据库
postgres2mysql.json
{
"job": {
"setting": {
"speed": {
"channel": 3
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [{
"reader": {
"name": "postgresqlreader",
"parameter": {
"username": "postgres",
"password": "APIB9hRP",
"column": [
"id",
"name",
"age",
"address",
"salary"
],
"splitPk": "id",
"connection": [{
"table": [
"company"
],
"jdbcUrl": [
"jdbc:postgresql://localhost:5432/datax?serverTimezone=UTC"
]
}]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "APIB9hRP",
"column": [
"id",
"name",
"age",
"address",
"salary"
],
"session": [
"set session sql_mode='ANSI'"
],
"preSql": [
"delete from company"
],
"connection": [{
"table": [
"company"
],
"jdbcUrl": "jdbc:mysql://localhost:3306/datax?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8"
}]
}
}
}]
}
}
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/140802.html
