2.Datax数据同步之Windows、mysql和sqlserver之间的自定义sql文本数据同步--分步详解

mysql和sql server创建好对应的数据库和表结构如下图所示


安装sql server2012时，.NET Framework3.5必须被勾选中，否则最后一步无法完全安装成功

如果遇到了0x80080005 windows更新失败导致的net framework3.5安装失败
点击该作者博客迅速解决

mysql 至 sqlServer

撰写mysql同步至sqlServer的json文件

{
    "job": {
        "setting": {
            "speed": {
                "channel":1
            },
            "errorLimit": {
                "record": 0,
                "percentage": 0.02
            }
        },
        "content": [
            {
                "reader": {
                    "name": "mysqlreader",
                    "parameter": {
						"username": "root", 
						"password": "123456",
                        "connection":[
							{
								"jdbcUrl":["jdbc:mysql://127.0.0.1:3306/lvyy_test"],
								"querySql":["select id,name,content,createdate from t_user_info where id > 1"]
							}
						]
                    }
                },
                "writer": {
                    "name": "sqlserverwriter",
                    "parameter": {
                        "username": "sa",
						"password":"123456",
						"column": ["id","name","contents","createdate"],
						"preSql":["delete from t_user_info"],
						"connection":[
							{
								"jdbcUrl":"jdbc:sqlserver://127.0.0.1:1433/lvyy01",
								"table":["t_user_info"]
							}
						]
                    }
                }
            }
        ]
    }
}

windows终端执行同步文件
如果遇到报错：The server selected protocol version TLS10 is not accepted by client preferences [TLS12]
点击该作者博客迅速解决


结果如下

sqlServer 至 mysql

撰写SqlServer同步至mysql的json文件

{
    "job": {
        "setting": {
            "speed": {
                "channel": 1
            }
        },
        "content": [
            {
				"reader": {
                    "name": "sqlserverreader",
                    "parameter": {
                        "username": "sa",
						"password": "123456",
                        "connection": [
                            {
                                "jdbcUrl": [
                                    "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=lvyy01"
                                ],
								"querySql":["select id, name, contents, createdate from t_user_info where id < 3"]
                            }
                        ]
                    }
                },
				"writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                        "username": "root",
                        "password": "123456",
                        "column": [ "id", "name","content","createdate"],
                        "preSql": [
                            "delete from t_user_info"
                        ],
                        "connection": [
                            {
                                "jdbcUrl": "jdbc:mysql://127.0.0.1:3306/lvyy0102?useSSL=false&useUnicode=true&characterEncoding=utf-8",
                                "table": [
                                    "t_user_info"
                                ]
                            }
                        ]
                    }
                }
            }
        ]
    }
}

windows终端执行同步文件


结果如下

执行同步语句中报