DataX 数据转换之SqlSErver 至PostgreSql 数据库样例

 

{
  "job": {
    "content": [
      {
        "reader":
        {
            "name": "sqlserverreader",
            "parameter": {
            "username": "****",
            "password": "****",
             "column": ["*"],
            "connection": [
                {
                "table": ["invoice"],
                "jdbcUrl": ["jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test"]
                }
            ]
            }
},
"writer":{
    "name": "postgresqlwriter",
    "parameter": {
        "username": "test",
        "password": "test",
        "column": ["*"],
        "preSql": [],
        "connection": [
            {
                "jdbcUrl": "jdbc:postgresql://127.0.0.1/database",
                "table": ["invoice"]
            }
        ],
        "preSql": [],
        "postSql": []
    }
}
}
],
"setting": {
      "speed": {
        "channel": 5
       }
    }
  }
}