MTK Parameter

Parameter

excludeSysTable

类型: []string

描述: 排除系统对象定义。不配置则使用默认值

示例:

DB2 Exclude System Table example

{
  "excludeSysTable": [
    "EXPLAIN_ACTUALS",
    "ADVISE_TABLE",
    "ADVISE_PARTITION",
    "ADVISE_MQT",
    "ADVISE_WORKLOAD",
    "ADVISE_INDEX",
    "ADVISE_INSTANCE",
    "OBJECT_METRICS",
    "EXPLAIN_DIAGNOSTIC_DATA",
    "EXPLAIN_DIAGNOSTIC",
    "EXPLAIN_STREAM",
    "EXPLAIN_PREDICATE",
    "EXPLAIN_OPERATOR",
    "EXPLAIN_OBJECT",
    "EXPLAIN_ARGUMENT",
    "EXPLAIN_STATEMENT",
    "EXPLAIN_INSTANCE"
  ]
}

enableSyncCompTabPro

类型: bool

描述: 是否配置生成DDL包含表压缩属性语法。默认不生成。

默认值: false

tableOptions

类型: map[string]string

描述: 配置在创建表的时候添加表属性选项.暂时只支持openGauss/MogDB.

openGauss/MogDB create table xxx() with (xx);

参数不区分大小写

"*" 迁移对象中所有表
"Schema1.*" 迁移对象中Schema1下所有表
"Schema1.TABLE_1" 迁移对象中Schema1下table表

选项特殊值 remove

如 compression=remove 会移除压缩属性

默认值: null

示例:

Table Options Example

{
  "tableOptions": {
    "*": "orientation=row, compression=no",
    "schema1.*": "orientation=row, compression=no",
    "schema1.table_1": "orientation=row, compression=no"
  }
}

Table Options Regexp Example

{
  "tableOptions": {
    "schema1.table_1": "orientation=row, compression=no",
    "schema1.table_duty_log*": "orientation=row, compression=no",
    "schema1.^table_duty_log*": "orientation=row, compression=no",
    "schema1.*": "orientation=row, compression=no",
    "*": "orientation=row, compression=no"
  }
}

新增于: v2.3.2

indexOptions

类型: map[string]string

描述: 和tableOptions选项配置一样,只针对索引生效.

默认值: null

新增于: v2.3.2