1、MTK工具介绍和MTK工具安装
---------
这里先不介绍mtk的工具和安装
https://www.modb.pro/db/456192
2、配置 ora2mog.json
```
[root@ccc config]# cat mtk2.json
{
"source": {
"type": "mysql",
"connect": {
"version": "",
"host": "192.168.3.4",
"user": "dbmt",
"port": 3306,
"password": "dba_OPS_123",
"dbName": "pfmc",
"dsn": ""
},
"parameter": {
"debugTest": false
}
},
"target": {
"type": "openGauss",
"connect": {
"version": "",
"host": "192.168.3.6",
"user": "dbmt",
"port": 26000,
"password": "dba_OPS_123",
"dbName": "pxc1",
"dsn": ""
},
"parameter": {
"dropExistingObject": true,
"truncTable": true,
"ignoreTableDDLCompErr": true,
"parallelInsert": 1
}
},
"limit": {
"parallel": 2
},
"dataOnly": false ,
"schemaOnly": false,
"reportFile": "/opt/software/report_mysql2Omogdb_all.html"
}
```
3、执行mtk
```
./mtk -c my2mg/config/mtk2.json
```
4、执行后结果
```
}" file="mtk/pkg/mtk/mtk.go" taskID=1637738722000637952 function=func1 line=214
time="2023-03-20 16:51:53.696819" level=info msg="the connect database using: dbmt:******@tcp(192.168.3.4:3306)/pfmc?loc=Local&multiStatements=true&timeout=30s&maxAllowedPacket=1073741824&charset=utf8" function=printDNSNoPwd line=210 file="mtk/pkg/databases/mysql/dsn.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.248986" level=info msg="CollTableStatistics pfmc.workflow_org" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.249471" level=info msg="CollTableStatistics pfmc.workflow_role" taskID=1637738722000637952 function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go"
time="2023-03-20 16:52:24.250659" level=info msg="CollTableStatistics pfmc.workflow_role_account" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.251431" level=info msg="CollTableStatistics pfmc.workflow_user" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.25179" level=info msg="CollTableStatistics pfmc.workflow_user_account_org" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.252101" level=info msg="CollTableStatistics pfmc.xno_4a_login_log" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.252357" level=info msg="CollTableStatistics pfmc.xno_4a_ops_log" function=doTask line=538 file="mtk/pkg/mtk/mtk_task.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.267969" level=info msg="Processing CollStatistics finish" file="mtk/pkg/mtk/mtk.go" taskID=1637738722000637952 function=doTask line=446
time="2023-03-20 16:52:24.268011" level=info msg="Finish Begin" function=Stop line=244 file="mtk/pkg/mtk/mtk.go" taskID=1637738722000637952
time="2023-03-20 16:52:24.268208" level=info msg="Finish end" function=Stop line=250 file="mtk/pkg/mtk/mtk.go" taskID=1637738722000637952
*********************************
Database Migration Toolkit Report
*********************************
--------------
Report Summary
--------------
| Name | Value |
|--------------------------------|---------------------|
| Source Database Type | mysql |
| Source Database Version | 8.0.30 |
| Source Database Charset | |
| Source Database DatCompat | |
| Target Database Type | openGauss |
| Target Database Version | 3.0.0 |
| Target Database Charset | UTF8 |
| Target Database DatCompat | B |
| StartTime | 2023-03-20 16:51:53 |
| EndTime | 2023-03-20 16:52:24 |
| Time | 30 s |
| Status | finish |
| MTK Version | v2.8.3_43391a3f |
-----------------------
ObjectName Type Summary
-----------------------
+------------------+-------------------+-------------------+--------+-----------+-------------+-------------+-------------+--------------------|-------------+
| Type | StartTime | EndTime | Status | Total Num | Success Num | Warring Num | Failed Num |Failed(Invalid) Num | Time |
+------------------+-------------------+-------------------+--------+-----------+-------------+-------------+-------------+--------------------|-------------+
|Schema |2023-03-20 16:51:53|2023-03-20 16:51:53|finish |1 |1 |0 |0 |0 |3 ms ｜
|Sequence |2023-03-20 16:51:53|2023-03-20 16:51:53|finish |1 |1 |0 |0 |0 |16 ms ｜
|Table |2023-03-20 16:51:53|2023-03-20 16:51:55|finish |256 |251 |5 |0 |0 |1 s 509 ms ｜
|TableData |2023-03-20 16:51:55|2023-03-20 16:52:15|finish |256 |256 |0 |0 |0 |19 s 888 ms ｜
|Index |2023-03-20 16:52:15|2023-03-20 16:52:15|finish |390 |370 |20 |0 |0 |9 ms ｜
|Constraint |2023-03-20 16:52:15|2023-03-20 16:52:15|finish |331 |78 |253 |0 |0 |166 ms ｜
|View |2023-03-20 16:52:15|2023-03-20 16:52:15|finish |0 |0 |0 |0 |0 |1 ms ｜
|Function |2023-03-20 16:52:15|2023-03-20 16:52:15|finish |0 |0 |0 |0 |0 |1 ms ｜
|Procedure |2023-03-20 16:52:15|2023-03-20 16:52:15|finish |0 |0 |0 |0 |0 |0 ms ｜
|Trigger |2023-03-20 16:52:15|2023-03-20 16:52:15|finish |0 |0 |0 |0 |0 |0 ms ｜
|TableDataCom |2023-03-20 16:52:15|2023-03-20 16:52:22|finish |256 |256 |0 |0 |0 |7 s 639 ms ｜
|AlterSequence |2023-03-20 16:52:22|2023-03-20 16:52:22|finish |1 |1 |0 |0 |0 |11 ms ｜
|CollStatistics |2023-03-20 16:52:22|2023-03-20 16:52:24|finish |256 |256 |0 |0 |0 |1 s 285 ms ｜
+------------------+-------------------+-------------------+--------+-----------+-------------+-------------+-------------+--------------------|-------------+
[2023-03-20 16:52:24.27619] INFO reportDir : /opt/software/report_mysql2Omogdb_all file=mtk/cmd/mtk/cmd/mtk.go function=PrintReport line=364
[2023-03-20 16:52:24.292008] INFO the text report : /opt/software/report_mysql2Omogdb_all.txt function=HTMLReportToFIle line=134 file=mtk/pkg/report/report.go
[2023-03-20 16:52:24.375814] INFO the warring report : /opt/software/report_mysql2Omogdb_all.warring function=HTMLReportToFIle line=141 file=mtk/pkg/report/report.go
[2023-03-20 16:52:24.387054] INFO the error report : /opt/software/report_mysql2Omogdb_all.err function=HTMLReportToFIle line=148 file=mtk/pkg/report/report.go
[2023-03-20 16:52:24.388647] INFO the excel report : /opt/software/report_mysql2Omogdb_all.xlsx file=mtk/pkg/report/report.go function=HTMLReportToFIle line=155
,
```
5、可以查看html文件
