datax（配置模板）不同数据库间-数据同步

最新推荐文章于 2024-09-05 23:08:02 发布

@年轻人@

最新推荐文章于 2024-09-05 23:08:02 发布

阅读量512

点赞数

本文链接：https://blog.csdn.net/qq_39942956/article/details/118672096

版权

{
    "job": {
        "setting": {
            "speed": {
                "channel": 1
            }
        },
        "content": [
            {
                "reader": {
                    "name": "sqlserverreader",
                    "parameter": {
                        "username": "1111111",
                        "password": "1111111",
                        "column": ["Id","Enabled",.....],
                        "connection": [
                            {
                                "table": [
                                    "dbo.Clients"
                                ],
                                "jdbcUrl": [
                                    "jdbc:sqlserver://*.*.*.*:7010;DatabaseName=*******;"
                                ]
                            }
                        ]
                    }
                },
                "writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                        "writeMode": "insert",
                        "username": "root",
                        "password": "*****",
                        "column": [ "Id","Enabled",.....],
                        "connection": [
                            {
                                "jdbcUrl": "jdbc:mysql://*.*.*.*:3306/*******",
                                "table": [
                                    "Clients"
                                ]
                            }
                        ]
                    }
                }
            }
        ]
    }
}