MTK Parameter

Parameter

dropSchema

Type: bool

Desc: Drops the schema if it already exists in the target database.

Default: false

Option:

• true
• false

Add: v2.7.0

dropExistingObject

Type: bool

Desc: Drop the object if the object already exists in the target database.

Generally used when data is reinitialized. Please use it with caution. Drop schema is not supported after 2.7.0.

Default: false

Option:

• true
• false

skipExistPLSQL

Type: bool

Desc: if you need not override existing functions or views disable this configuration directive, DDL will not include OR REPLACE

Default: false

Option:

• true
• false

Add: v2.8.4

truncTable

Type: bool

Desc: Truncate table for the table when migrating data.

Default: false

Option:

• true
• false

colKeyWords

Type: map[string]int

Desc: Column name keyword。 When the target is created, "" will be automatically added or the keyword will be case-converted

• 0 keyword is kept unchanged.
• 1 indicates lowercase.
• 2 indicates uppercase

Option:

• 0
• 1
• 2

Example:

Column KeyWords example

{
  "colKeyWords": {
    "COL_STREAM": 1,
    "COL_TID": 1
  }
}

objKeyWords

Type: map[string]int

Desc: Object name keyword。 When the target is created, "" will be automatically added or the keyword will be case-converted

• 0 keyword is kept unchanged.
• 1 indicates lowercase.
• 2 indicates uppercase

Option:

• 0
• 1
• 2

Example:

Column KeyWords example

{
  "objKeyWords": {
    "COL_STREAM": 1,
    "COL_TID": 1
  }
}

caseSensitive

Type: int

Desc: Case conversion for generated object names.

• 0 indicates that no operation is needed.
• 1 indicates lowercase.
• 2 indicates uppercase

Default: 0

Option:

• 0
• 1
• 2

quoteMark

Type: bool

Desc: Use double or back-quote inclusion for object names in SQL statements.

-- MySQl
`a1`
-- Oracle/PostgreSQL/openGauss/MogDB
"a1"

-- quoteMark: false
CREATE TABLE mtk.t_pri (
  id DECIMAL(38) NOT NULL,
  id2 DECIMAL(38) NOT NULL,
  id3 DECIMAL(38),
  id4 DECIMAL(38),
  id5 DECIMAL(38)
);

-- quoteMark: true
CREATE TABLE "mtk"."t_pri" (
  "id" DECIMAL(38) NOT NULL,
  "id2" DECIMAL(38) NOT NULL,
  "id3" DECIMAL(38),
  "id4" DECIMAL(38),
  "id5" DECIMAL(38)
);

Can be used with the parametercaseSensitivefor object name case conversion. Except for special keywords, special keywords use objKeyWords and colKeyWords

Default: false

Option:

• true
• false

ignoreTableDDLCompErr

Type: bool

Desc: Indicates whether to ignore the table structure comparison error.

Default: false

Deprecated: 功能废弃

Option:

• true
• false

parallelIndex

Type: int

Desc: Enable parallel creation of indexes for openGauss/MogDB, and the maximum parallelism of a single index is 32.

The total parallelism limit.parallel * parallelIndex should be less than max_connections*1/4. If the maximum number of database connections is 400, the maximum number of threads provided to create an index at the database level is 400*1/4, which is 100

If limit.parallel * parallelIndex is greater than 100, the database will be automatically converted to serial creation. That is, configure parallelIndex=8, then limit.parallel can be up to 12

Default: 0

Add: v2.7.1

enableGlobalIndexToLocal

Type: bool

Desc: Convert the GLOBAL index of the non-unique index on the partition table to the LOCAL index. Only the target side is openGauss/MogDB

Default: false

Option:

• true
• false

Add: v2.7.3