MTK Usage

Show Version

./mtk version

Apply the license

./mtk license gen

Migrate Oracle To MogDB

Migrating Oracle to MogDB FAQ reference Oracle To MogDB

Install Oracle Client

init project

./mtk init-project -s oracle -t mogdb -n ora2mg
# will build a migration directory
ora2mg
├── config
│   └── mtk.json
├── data
├── report
└── schema

edit the configuration file

Edit the configuration file in advance. For details, see Configuration File

vi ora2mg/config/mtk.json

1. Edit source node to define the source database connection information. Configuration reference source

2. Edit target node to define the target database connection information. Configuration reference target

   Modify the connect and type information, and the parameter is adjusted according to the operation

3. Edit object node to define the migration object. Configuration reference object

After editing, run config-check

./mtk config-check -c ora2mg/config/mtk.json

The configuration file will output type information normally

use config : ora2mg/config/mtk.json
There is no error in the configuration file

run

./mtk -c ora2mg/config/mtk.json
# debug
./mtk -c ora2mg/config/mtk.json --debug
# only Schema is migrated
./mtk -c ora2mg/config/mtk.json --schemaOnly
# Only Data is migrated
./mtk -c ora2mg/config/mtk.json --dataOnly

view Report

Reports and run logs are generated in the ora2og/report directory. as follows

[2022-01-20 11:29:25.800978]  INFO reportDir: ora2mg/report/report_20220120110125 function=GenReport line=412 file=mtk/cmd/mtk/services/cmd.go
[2022-01-20 11:29:26.426822]  INFO the text report : ora2mg/report/report_20220120110125.txt function=PrintReport line=270 file=mtk/cmd/mtk/services/cmd.go
[2022-01-20 11:29:26.429545]  INFO the warring report : ora2mg/report/report_20220120110125.warring function=PrintReport line=281 file=mtk/cmd/mtk/services/cmd.go
[2022-01-20 11:29:26.430118]  INFO the error report : ora2mg/report/report_20220120110125.err file=mtk/cmd/mtk/services/cmd.go function=PrintReport line=292

export as a file

./mtk -c ora2mg/config/mtk.json --file
# Only Schema is migrated
./mtk -c ora2mg/config/mtk.json --file --schemaOnly
# Only Data is migrated
./mtk -c ora2mg/config/mtk.json --file --dataOnly

The command line specifies the migration object

# specify the table
./mtk -c ora2mg/config/mtk.json --tables schema1.table1,schema2.table2
# specify the schema
./mtk -c ora2mg/config/mtk.json --schemas schema1,schema2

Migrate MySQL to MogDB

Migrating MySQL to MogDB FAQ reference MySQL To MogDB

init project

./mtk init-project -s mysql -t mogdb -n my2mg

edit the configuration file

vi my2mg/config/mtk.json

1. Edit source node to define the source database connection information. Configuration reference source

2. Edit target node to define the target database connection information. Configuration reference target

   Modify the connect and type information, and the parameter is adjusted according to the operation

3. Edit object node to define the migration object. Configuration reference object

After editing, run config-check

./mtk config-check -c my2mg/config/mtk.json

The configuration file will output type information normally

use config : my2mg/config/mtk.json
There is no error in the configuration file

run

./mtk -c my2mg/config/mtk.json

Migrate DB2 to MogDB

Migrating DB2 to MogDB FAQ reference DB2 To MogDB

Install db2 Client

init project

./mtk init-project -s db2 -t mogdb -n db22mg

edit the configuration file

vi db22mg/config/mtk.json

1. Edit source node to define the source database connection information. Configuration reference source

2. Edit target node to define the target database connection information. Configuration reference target

   Modify the connect and type information, and the parameter is adjusted according to the operation

3. Edit object node to define the migration object. Configuration reference object

After editing, run config-check

./mtk config-check -c db22mg/config/mtk.json

The configuration file will output type information normally

use config : db22mg/config/mtk.json
There is no error in the configuration file

run

./mtk -c db22mg/config/mtk.json

Migrate Informix to MogDB

Migrating Informix to MogDB FAQ reference Informix To MogDB

Install db2 Client

init project

./mtk init-project -s informix -t mogdb -n ifx2mg

edit the configuration file

vi ifx2mg/config/mtk.json

1. Edit source node to define the source database connection information. Configuration reference source

2. Edit target node to define the target database connection information. Configuration reference target

   Modify the connect and type information, and the parameter is adjusted according to the operation

3. Edit object node to define the migration object. Configuration reference object

After editing, run config-check

./mtk config-check -c ifx2mg/config/mtk.json

The configuration file will output type information normally

use config : ifx2mg/config/mtk.json
There is no error in the configuration file

run

./mtk -c ifx2mg/config/mtk.json

Migration methods

MTK supports three migration methods.

Migrate all at once

./mtk -c mtk.json

Combined migration

Step-by-step migration

The user controls the overall migration logic.