MTK Parameter

Parameter

path

Type: string

Desc: Indicates the directory of a file to which data is to be exported.

During data migration, the error data will be recorded in this directory to the err_data_ directory

Default: ./data

schemaPath

Type: string

Desc: sql script directory

dataPath

Type: string

Desc: data directory

errDataPath

Type: string

Desc: error data directory

fileType

Type: string

Desc: Indicates the type of file when data is to be exported to a file.

Option:

• csv
• sql

fileSize

Type: string

Desc: Indicates the size of a file when data is to be exported to a file. If this parameter is not configured, the file size is not limited.

Supported formats:

• KiB
• MiB
• GiB
• TiB
• PiB
• KB
• MB
• GB
• TB
• PB

KB == 1000

KiB == 1024

Example:

FileSize Example

{
  "fileSize": "2048MiB"
}

sqlDBType

Type: string

Desc: Indicates the data insert syntax in the target database when data is to be exported to a file.

For example, if data is migrated from Oracle to MySQL, the MySQL data insert syntax is generated by default.

csvHeader

Type: bool

Desc: Indicates whether the CSV file header is included when data is to be exported to a CSV file. The CSV header is not exported by default.

Default: false

csvNullValue

Type: string

Desc: csv empty value display

csvFieldDelimiter

Type: string

Desc: Indicates the default CSV delimiter.

Default: ,

csvOptionallyEnclosed

Type: string

Desc: Indicates the data wrapper.

Default: "

timeFormat

Type: string

Desc: define time format

Default: HH:MI:SS

dateFormat

Type: string

Desc: define date format

Default: YYYY-MM-DD

dateTimeFormat

Type: string

Desc: define datetime format

Default: YYYY-MM-DD HH24:MI:SS