备案控制台
文档
产品文档
输入文档关键字查找
首页 数据传输服务 开发参考 API参考 新版API（推荐） DTS任务请求参数示例 MySQL为源的迁移或同步任务请求参数示例

MySQL为源的迁移或同步任务请求参数示例

更新时间：
一键部署
产品详情
相关技术圈
我的收藏

本文介绍MySQL为源的迁移或同步任务请求参数示例。

请求示例概览

链路

请求示例

MySQL间的迁移或同步任务请求参数示例

MySQL迁移或同步至云原生数据仓库 AnalyticDB MySQL 版 3.0请求参数示例

MySQL迁移或同步至云原生数据仓库 AnalyticDB PostgreSQL 版请求参数示例

MySQL迁移或同步至DataHub请求参数示例

MySQL迁移或同步至Elasticsearch请求参数示例

MySQL迁移或同步至MaxCompute请求参数示例

MySQL迁移或同步至PolarDB MySQL请求参数示例

MySQL迁移或同步至Oracle请求参数示例

RDS MySQL间的同步任务

{
    "dtsJobName": "mysql-mysql",
    "jobType": "SYNC",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp16b5sl870s6****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointRole": "ram-for-dts",
    "sourceEndpointOwnerID": "118222062983****",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"srcSSL\":\"0\",\"destSSL\":\"0\",\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\",\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{}}",
    "dbList": "{\"dts\":{\"name\":\"dts\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts04\",\"all\":true,\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,tt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"varchar(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"createTable\":{\"name\":\"createTable\",\"all\":true}}},\"dtstest\":{\"name\":\"dtstest\",\"all\":true}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "RDS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "rm-bp1x876nwemsp****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "xcw11wmh22g****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至有公网IP的自建MySQL

{
    "dtsJobName": "mysql-mysql",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointRole": "ram-for-dts",
    "sourceEndpointOwnerID": "118222062983****",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"srcSSL\":\"0\",\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\",\"syncArchitecture\":\"bidirectional\",\"filterDDL\":\"false\",\"conflict\":\"overwrite\",\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{}}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true,\"conflict\":\"overwrite\"},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"conflict\":\"overwrite\",\"Table\":{\"dts\":{\"name\":\"dts04\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "OTHER",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "dts",
    "destinationEndpointIP": "47.100.XX.XX",
    "destinationEndpointPort": "3306",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL同步至ECS自建MySQL

{
    "dtsJobName": "mysql-mysql",
    "jobType": "SYNC",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"srcSSL\":\"0\",\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\",\"syncArchitecture\":\"oneway\",\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy');\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{}}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts04\",\"all\":true,\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di,tt\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,u\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "ECS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "destinationEndpointUserName": "dts",
    "destinationEndpointPort": "3306",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 10,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至RDS MySQL

{
    "dtsJobName": "mysql-mysql",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"destSSL\":\"0\",\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\",\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{}}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"insertInto\":{\"name\":\"insertInto\",\"all\":true}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "RDS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "rm-bp1x876nwemsp****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL间的迁移任务

{
    "dtsJobName": "mysql-mysql",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts04\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"insertInto\":{\"name\":\"insertInto\",\"all\":true}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "OTHER",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "dts",
    "destinationEndpointIP": "47.101.XX.XX",
    "destinationEndpointPort": "3306",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至ECS自建MySQL

{
    "dtsJobName": "mysql-mysql",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts04\",\"all\":true,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,tt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"insertInto\":{\"name\":\"insertInto\",\"all\":true}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "ECS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "destinationEndpointUserName": "dts",
    "destinationEndpointPort": "3306",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL同步至RDS MySQL

{
    "dtsJobName": "mysql-mysql",
    "jobType": "SYNC",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"srcSSL\":\"0\",\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\",\"syncArchitecture\":\"oneway\",\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy');\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{}}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts04\",\"all\":true,\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di,tt\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,u\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "RDS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "rm-bp1x876nwemsp****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 10,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至有公网IP的自建MySQL

{
    "dtsJobName": "mysql-mysql",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"dts\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts04\",\"all\":true,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"createTable\":{\"name\":\"createTable\",\"all\":true}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "OTHER",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "dts",
    "destinationEndpointIP": "47.100.XX.XX",
    "destinationEndpointPort": "3306",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL间的同步任务

{
    "dtsJobName": "mysql-mysql",
    "jobType": "SYNC",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"maxRetryTime\":43200,\"srcSSL\":\"0\",\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\",\"syncArchitecture\":\"bidirectional\",\"conflict\":\"overwrite\",\"filterDDL\":\"false\",\"syncArchitecture\":\"oneway\",\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy');\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{}}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts04\",\"all\":true,\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di,tt\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,u\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"},\"realname\":{\"name\":\"realname\",\"syntacticType\":\"ADD\",\"value\":\"bb\",\"type\":\"VARCHAR\"}}}}}}",
    "destinationEndpointEngineName": "MYSQL",
    "destinationEndpointInstanceType": "ECS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "destinationEndpointUserName": "dts",
    "destinationEndpointPort": "3306",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 10,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至AnalyticDB MySQL 3.0

{
    "dtsJobName": "mysql-adb30",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(`name`,'yy')\",\"srcSSL\":\"0\",\"adsSqlType\":\"insert,update,delete,createTable,alterTable,dropTable,truncateTable\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts\",\"all\":true,\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"partition\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"partition\"}}}}",
    "destinationEndpointEngineName": "ADB30",
    "destinationEndpointInstanceType": "ADS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "am-bp1956j57uy9w****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "f541174023j****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至AnalyticDB MySQL 3.0

{
    "dtsJobName": "mysql-adb30",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"adsSqlType\":\"insert,update,delete,alterTable\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts04\",\"all\":true,\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"partition\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"partition\"}}}}",
    "destinationEndpointEngineName": "ADB30",
    "destinationEndpointInstanceType": "ADS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "am-bp1956j57uy9w****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至AnalyticDB MySQL 3.0

{
    "dtsJobName": "mysql-adb30",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"adsSqlType\":\"insert,update,delete,alterTable\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"dts\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts1\",\"all\":true,\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"partition\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"partition\"}}}}",
    "destinationEndpointEngineName": "ADB30",
    "destinationEndpointInstanceType": "ADS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "am-bp1956j57uy9w****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL同步至AnalyticDB PostgreSQL

{
    "dtsJobName": "mysql-adbpg",
    "jobType": "SYNC",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"isTargetDbCaseSensitive\":true,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"srcSSL\":\"0\",\"syncOperation\":\"insert,update,delete,alterTable\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true,\"Table\":{\"dts1\":{\"name\":\"dts1\",\"all\":true,\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"},\"dts2\":{\"name\":\"dts2\",\"all\":true,\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"},\"dts3\":{\"name\":\"dts3\",\"all\":true,\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"}}},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"}}}}",
    "destinationEndpointEngineName": "GREENPLUM",
    "destinationEndpointInstanceType": "GREENPLUM",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "gp-bp1x2cx982wqp****",
    "destinationEndpointUserName": "dts",
    "destinationEndpointDataBaseName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "f6w11zrf23g****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至AnalyticDB PostgreSQL

{
    "dtsJobName": "mysql-adbpg",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"isTargetDbCaseSensitive\":true,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"syncOperation\":\"insert,update,delete,createTable,alterTable,dropTable,renameTable,truncateTable\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts08\",\"all\":true,\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,tt\",\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"}}}}",
    "destinationEndpointEngineName": "GREENPLUM",
    "destinationEndpointInstanceType": "GREENPLUM",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "gp-bp1x2cx982wqp****",
    "destinationEndpointUserName": "dts",
    "destinationEndpointDataBaseName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL同步至AnalyticDB PostgreSQL

{
    "dtsJobName": "mysql-adbpg",
    "jobType": "SYNC",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"isTargetDbCaseSensitive\":true,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"syncOperation\":\"insert,update,delete,createTable,alterTable,dropTable,renameTable,truncateTable\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"dts\",\"all\":false,\"Table\":{\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"part_key\":\"id\",\"primary_key\":\"id\",\"type\":\"normal\"}}}}",
    "destinationEndpointEngineName": "GREENPLUM",
    "destinationEndpointInstanceType": "GREENPLUM",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "gp-bp1x2cx982wqp****",
    "destinationEndpointUserName": "dts",
    "destinationEndpointDataBaseName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至DataHub

{
    "dtsJobName": "mysql-datahub",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"dml_op\":\"i,u,d\",\"ddl_op\":\"at\",\"whitelist.dms.online.ddl.enable\":true,\"sqlparser.dms.original.ddl\":false,\"maxRetryTime\":43200,\"isUseNewAttachedColumn\":false,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"srcSSL\":\"0\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"zwytest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\",\"sharedKey\":true},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\",\"sharedKey\":false}}}}}}",
    "destinationEndpointEngineName": "DATAHUB",
    "destinationEndpointInstanceType": "DATAHUB",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "zwytest****",
    "structureInitialization": true,
    "dataInitialization": false,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至DataHub

{
    "dtsJobName": "mysql-datahub",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"zwytest\",\"all\":false,\"Table\":{\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\",\"sharedKey\":true},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\",\"sharedKey\":false}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"insertInto\":{\"name\":\"insertInto\",\"all\":true}}}}",
    "destinationEndpointEngineName": "DATAHUB",
    "destinationEndpointInstanceType": "DATAHUB",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "zwytest****",
    "structureInitialization": true,
    "dataInitialization": false,
    "dataSynchronization": true,
    "dtsJobId": "c2o113uw24r****",
    "sourceEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至DataHub

{
    "dtsJobName": "mysql-datahub",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"isUseNewAttachedColumn\":true,\"disableAttachedDTSColumn\":true,\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"zwytest\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts1\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\",\"sharedKey\":true},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\",\"sharedKey\":false}}}}}}",
    "destinationEndpointEngineName": "DATAHUB",
    "destinationEndpointInstanceType": "DATAHUB",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "zwytest****",
    "structureInitialization": true,
    "dataInitialization": false,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至Elasticsearch

{
    "dtsJobName": "mysql-elk",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"indexMapping\":\"db_tb\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"srcSSL\":\"0\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true,\"index_mapping\":\"db_tb\",\"shard\":5,\"replica\":1,\"time_zone\":\"+8:00\",\"analysis\":\"analyzed\",\"analyzer\":\"standard\",\"Table\":{\"dts1\":{\"name\":\"dts_test_dts1\",\"all\":true,\"index\":\"dts_test_dts1\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"dts2\":{\"name\":\"dts_test_dts2\",\"all\":true,\"index\":\"dts_test_dts2\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"dts3\":{\"name\":\"dts_test_dts3\",\"all\":true,\"index\":\"dts_test_dts3\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"}}},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"index_mapping\":\"db_tb\",\"shard\":5,\"replica\":1,\"time_zone\":\"+8:00\",\"analysis\":\"analyzed\",\"analyzer\":\"standard\",\"Table\":{\"dts\":{\"name\":\"dtstest_dts\",\"all\":true,\"index\":\"dtstest_dts\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"zwytest\":{\"name\":\"dtstest_zwytest\",\"all\":true,\"index\":\"dtstest_zwytest\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"}}}}",
    "destinationEndpointEngineName": "ELK",
    "destinationEndpointInstanceType": "ELK",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "es-cn-uqm2z0ncv0003****",
    "destinationEndpointUserName": "elastic",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至Elasticsearch

{
    "dtsJobName": "mysql-elk",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"indexMapping\":\"db_tb\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"srcSSL\":\"0\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true,\"index_mapping\":\"db_tb\",\"shard\":5,\"replica\":1,\"time_zone\":\"+8:00\",\"analysis\":\"analyzed\",\"analyzer\":\"standard\",\"Table\":{\"dts1\":{\"name\":\"dts_test_dts1\",\"all\":true,\"index\":\"dts_test_dts1\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"dts2\":{\"name\":\"dts_test_dts2\",\"all\":true,\"index\":\"dts_test_dts2\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"dts3\":{\"name\":\"dts_test_dts3\",\"all\":true,\"index\":\"dts_test_dts3\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"}}},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"index_mapping\":\"db_tb\",\"shard\":5,\"replica\":1,\"time_zone\":\"+8:00\",\"analysis\":\"analyzed\",\"analyzer\":\"standard\",\"Table\":{\"dts\":{\"name\":\"dtstest_dts\",\"all\":true,\"index\":\"dtstest_dts\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"zwytest\":{\"name\":\"dtstest_zwytest\",\"all\":true,\"index\":\"dtstest_zwytest\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"}}}}",
    "destinationEndpointEngineName": "ELK",
    "destinationEndpointInstanceType": "ELK",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "es-cn-uqm2z0ncv0003****",
    "destinationEndpointUserName": "elastic",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "zer114oh241****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至Elasticsearch

{
    "dtsJobName": "mysql-elk",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"indexMapping\":\"tb\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"srcSSL\":\"0\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"dts\",\"all\":false,\"index_mapping\":\"tb\",\"shard\":5,\"replica\":1,\"time_zone\":\"+8:00\",\"analysis\":\"analyzed\",\"analyzer\":\"standard\",\"Table\":{\"dts1\":{\"name\":\"dts_dts1\",\"all\":true,\"index\":\"dts_dts1\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"},\"zwytest\":{\"name\":\"dts_zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\",\"index_value\":true},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\",\"index_value\":true}},\"index\":\"dts_zwytest\",\"is_partition\":false,\"_id\":\"primary_key\",\"_idvalue\":\"id\"}}}}",
    "destinationEndpointEngineName": "ELK",
    "destinationEndpointInstanceType": "ELK",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "es-cn-uqm2z0ncv0003****",
    "destinationEndpointUserName": "elastic",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "zer114oh241****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至MaxCompute

{
    "dtsJobName": "mysql-maxcompute",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"srcSSL\":\"0\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"portal_test\",\"all\":true,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"},\"dtstest\":{\"name\":\"portal_test\",\"all\":false,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\",\"Table\":{\"dts\":{\"name\":\"dts\",\"all\":true,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"}}}}",
    "destinationEndpointEngineName": "ODPS",
    "destinationEndpointInstanceType": "ODPS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "主账号AccessKeyId",
    "destinationEndpointDataBaseName": "portal_test",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "主账号AccessKeySecret",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至MaxCompute

{
    "dtsJobName": "mysql-maxcompute",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"portal_test\",\"all\":true,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"},\"dtstest\":{\"name\":\"portal_test\",\"all\":false,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\",\"Table\":{\"dts\":{\"name\":\"dts\",\"all\":true,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"}}}}",
    "destinationEndpointEngineName": "ODPS",
    "destinationEndpointInstanceType": "ODPS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "主账号AccessKeyId",
    "destinationEndpointDataBaseName": "portal_test",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "主账号AccessKeySecret",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至MaxCompute

{
    "dtsJobName": "mysql-maxcompute",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"portal_test\",\"all\":false,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\",\"Table\":{\"dts1\":{\"name\":\"dts1\",\"all\":true,\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}},\"partition\":\"modifytime_year,modifytime_month,modifytime_day,modifytime_hour\"}}}}",
    "destinationEndpointEngineName": "ODPS",
    "destinationEndpointInstanceType": "ODPS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "主账号AccessKeyId",
    "destinationEndpointDataBaseName": "portal_test",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "主账号AccessKeySecret",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至PolarDB MySQL

{
    "dtsJobName": "mysql-polardb",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"etlOperatorSetting\":\"e_set(name,'yy')\",\"srcSSL\":\"0\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"dts_test\",\"all\":true},\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "POLARDB",
    "destinationEndpointInstanceType": "POLARDB",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "pc-bp178dz5o86q2****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至PolarDB MySQL

{
    "dtsJobName": "mysql-polardb",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"etlOperatorSetting\":\"e_set(name,'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dtstest\":{\"name\":\"dtstest\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"dts\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"insertInto\":{\"name\":\"insertInto\",\"all\":true}}}}",
    "destinationEndpointEngineName": "POLARDB",
    "destinationEndpointInstanceType": "POLARDB",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "pc-bp178dz5o86q2****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至PolarDB MySQL

{
    "dtsJobName": "mysql-polardb",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"isUseNewAttachedColumn\":true,\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"whitelist.dms.online.ddl.enable\":false,\"sqlparser.dms.original.ddl\":true,\"etlOperatorSetting\":\"e_set(name,'yy')\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"dts\",\"all\":false,\"Table\":{\"dts1\":{\"name\":\"dts1\",\"all\":true},\"zwytest\":{\"name\":\"zwytest\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,cv,av,dv,cf,df,cp,ap,dp,ctr,dtr,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}},\"View\":{\"view_zwytest\":{\"name\":\"view_zwytest\",\"all\":true}},\"Function\":{\"genPerson\":{\"name\":\"genPerson\",\"all\":true}},\"Procedure\":{\"createTable\":{\"name\":\"createTable\",\"all\":true}}}}",
    "destinationEndpointEngineName": "POLARDB",
    "destinationEndpointInstanceType": "POLARDB",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "pc-bp178dz5o86q2****",
    "destinationEndpointUserName": "dts",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至有公网IP的自建Oracle

{
    "dtsJobName": "mysql-oracle",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"srcSSL\":\"0\",\"destOracleType\":\"serviceName\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"READER\",\"all\":true},\"dtstest\":{\"name\":\"READER\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"DTS\",\"all\":true},\"zwytest\":{\"name\":\"ZWYTEST\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "ORACLE",
    "destinationEndpointInstanceType": "OTHER",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "reader",
    "destinationEndpointDataBaseName": "orclpdb1",
    "destinationEndpointIP": "47.100.XX.XX",
    "destinationEndpointPort": "1528",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "f0211ria24v****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

RDS MySQL迁移至ECS自建Oracle

{
    "dtsJobName": "mysql-oracle",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "RDS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "rm-bp1a8jp2jjyzt****",
    "sourceEndpointUserName": "dts",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"srcSSL\":\"0\",\"destOracleType\":\"serviceName\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"READER\",\"all\":true},\"dtstest\":{\"name\":\"READER\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"DTS\",\"all\":true},\"zwytest\":{\"name\":\"ZWYTEST\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "ORACLE",
    "destinationEndpointInstanceType": "ECS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "i-bp1b30478zf5xb7j****",
    "destinationEndpointUserName": "reader",
    "destinationEndpointDataBaseName": "orclpdb1",
    "destinationEndpointPort": "1528",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至有公网IP的自建Oracle

{
    "dtsJobName": "mysql-oracle",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"destOracleType\":\"serviceName\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"READER\",\"all\":true,\"dml_op\":\"i,u,d\",\"ddl_op\":\"ct,at,dt,rt,tt,ci,di\"},\"dtstest\":{\"name\":\"READER\",\"all\":false,\"dml_op\":\"i,d,u\",\"ddl_op\":\"ct,at,dt,rt,tt,ci,di\",\"Table\":{\"dts\":{\"name\":\"DTS\",\"all\":true},\"zwytest\":{\"name\":\"ZWYTEST\",\"all\":false,\"filter\":\"id>0\",\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "ORACLE",
    "destinationEndpointInstanceType": "OTHER",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "reader",
    "destinationEndpointDataBaseName": "orclpdb1",
    "destinationEndpointIP": "47.101.XX.XX",
    "destinationEndpointPort": "1528",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

有公网IP的自建MySQL迁移至ECS自建Oracle

{
    "dtsJobName": "mysql-oracle",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "OTHER",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointUserName": "dts",
    "sourceEndpointIP": "47.100.XX.XX",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name, 'yy')\",\"srcSSL\":\"0\",\"destOracleType\":\"serviceName\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts_test\":{\"name\":\"READER\",\"all\":true},\"dtstest\":{\"name\":\"READER\",\"all\":false,\"Table\":{\"dts\":{\"name\":\"DTS\",\"all\":true},\"zwytest\":{\"name\":\"ZWYTEST\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "ORACLE",
    "destinationEndpointInstanceType": "ECS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "i-bp1b30478zf5xb7j****",
    "destinationEndpointUserName": "reader",
    "destinationEndpointDataBaseName": "orclpdb1",
    "destinationEndpointPort": "1528",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "bi911b8o245****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至有公网IP的自建Oracle

{
    "dtsJobName": "mysql-oracle",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"destOracleType\":\"serviceName\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"READER\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"Table\":{\"dts1\":{\"name\":\"DTS1\",\"all\":true},\"zwytest\":{\"name\":\"ZWYTEST\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "ORACLE",
    "destinationEndpointInstanceType": "OTHER",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointUserName": "reader",
    "destinationEndpointDataBaseName": "orclpdb1",
    "destinationEndpointIP": "47.100.XX.XX",
    "destinationEndpointPort": "1528",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "p05115j625x****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}

ECS自建MySQL迁移至ECS自建Oracle

{
    "dtsJobName": "mysql-oracle",
    "jobType": "MIGRATION",
    "sourceEndpointEngineName": "MYSQL",
    "sourceEndpointInstanceType": "ECS",
    "sourceEndpointRegion": "cn-hangzhou",
    "sourceEndpointInstanceID": "i-bp10jp1amwk4764k****",
    "sourceEndpointUserName": "dts",
    "sourceEndpointPort": "3306",
    "reserve": "{\"targetTableMode\":\"0\",\"dbListCaseChangeMode\":\"default\",\"maxRetryTime\":43200,\"etlOperatorCtl\":\"Y\",\"etlOperatorSetting\":\"e_set(name,'yy')\",\"destOracleType\":\"serviceName\",\"configKeyMap\":[{\"moduleCode\":\"03\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"04\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"},{\"moduleCode\":\"07\",\"etlOperatorColumnReference\":\"etlOperatorColumnReference\",\"etlOperatorSetting\":\"etlOperatorSetting\"}],\"etlOperatorColumnReference\":{},\"a2aFlag\":\"2.0\",\"autoStartModulesAfterConfig\":\"none\"}",
    "dbList": "{\"dts\":{\"name\":\"READER\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"Table\":{\"dts1\":{\"name\":\"DTS1\",\"all\":true},\"zwytest\":{\"name\":\"ZWYTEST\",\"all\":false,\"dml_op\":\"i,d\",\"ddl_op\":\"ct,at,dt,rt,ci,di\",\"column\":{\"id\":{\"key\":\"PRI\",\"name\":\"id\",\"type\":\"int\"},\"name\":{\"key\":\"\",\"name\":\"name\",\"type\":\"char(20)\"}}}}}}",
    "destinationEndpointEngineName": "ORACLE",
    "destinationEndpointInstanceType": "ECS",
    "destinationEndpointRegion": "cn-hangzhou",
    "destinationEndpointInstanceID": "i-bp1b30478zf5xb7j****",
    "destinationEndpointUserName": "reader",
    "destinationEndpointDataBaseName": "orclpdb1",
    "destinationEndpointPort": "1528",
    "structureInitialization": true,
    "dataInitialization": true,
    "dataSynchronization": true,
    "dtsJobId": "p05115j625x****",
    "sourceEndpointPassword": "Test****",
    "destinationEndpointPassword": "Test****",
    "delayNotice": true,
    "delayPhone": "1390000****",
    "delayRuleTime": 1,
    "errorNotice": true,
    "errorPhone": "1390000****"
}
文档推荐
  • 本页导读 （1）
文档反馈