datax中sqlserver 数据同步到sqlserver

最新推荐文章于 2024-06-28 23:04:57 发布

INSNNP_LZM

最新推荐文章于 2024-06-28 23:04:57 发布

阅读量2.3k

点赞数

本文链接：https://blog.csdn.net/qq_39146974/article/details/106281788

版权

网上的好多例子都是失败的，最后看的官方文档成功了。
json文件

{
    "job": {
        "setting": {
            "speed": {
                "channel": 5
            }        },
        "content": [
            {
                "reader": {
                    "name": "sqlserverreader",
                    "parameter": {
                        "username": "xx",
                        "password": "xx",
                        "where": "",
                        "connection": [
                            {
                                "querySql": [
                  	"select * from dbo.test01;"
                                ],
                                "jdbcUrl": [
                                    "jdbc:sqlserver://192.168.130.122:1433;DatabaseName=HX"
                                ]
                            }
                        ]
                    }
                },
                "writer": {
                    "name": "sqlserverwriter",
                    "parameter": {
                        "username": "xx",
                        "password": "xx",
                        "column": [
                            "id",
                            "ids",
                            "age"
                        ],
                        "connection": [
                            {
                                "table": [
                                    "dbo.tests01"
                                ],
                                "jdbcUrl": "jdbc:sqlserver://192.168.130.122:1433;DatabaseName=HXS"
                            }
                        ]
                    }
                }
            }
        ]
    }
}