MTK Usage

Show Version

./mtk version

Apply the license

./mtk license gen

Common Command

./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
# export to file
./mtk -c ora2mg/config/mtk.json --file
# 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 Oracle To MogDB

Migrating Oracle to MogDB FAQ reference Oracle To MogDB

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.