HomeMogDBMogDB StackUqbar

Documentation:v2.0

Supported Versions:

mtk mvd

Run the MVD for data verification

Synopsis

Run the MVD for data verification MVD Version >= 3.4.1

mtk mvd [flags]

Examples

  mtk -c mtk.json mvd
  mtk -c mtk.json mvd --table ora_mtk.emp --table ora_mtk.emp1

Options

  -h, --help                help for mvd
      --sample-pct float    Sample percent in sample comparison (value must between 0 and 1), default 1 means compare all data
      --sample-size float   Minimal size in MB when using sample comparison (partial data comparison), default 10240 means >= 10GB
  -t, --table strings       Specifies the name of the table to compare. Can be configured multiple times

Options inherited from parent commands

      --caseSensitive int       Object case parameters in SQL statements.
                                1 - lower case 
                                2 - upper case 
                                3 - Keep it the same as the source database.
  -c, --config string           Set mtk config file. Support json,yaml. [env MTK_CONFIG] (default "mtk.json")
  -d, --debug                   Set the debug mode.
                                Not necessary for the normal usage. [env MTK_DEBUG]
      --disableIgnoreCase       Disable ignoring case queries
      --enableSyncCompTabPro    Enable Synchronize table compressed properties
      --file                    export to file
      --fileType string         Indicates the type of a file when data is to be exported to a file.
                                support csv,sql
      --license string          Specify the license file
      --noTerminalReport        The terminal does not print an overview of the migration report
  -p, --parallel int            Specify the parallelism. 
                                the degree of parallelism is now only useful when migrating table data and parallelism when creating an index. (default 1)
      --path string             Indicates the directory of a file to which data is to be exported. 
                                Default value is config.target.parameter.path. If not configured, the system default value ./data
                                Command Value > Config Value > MTK Default Value
      --preRun                  preRun check.
  -r, --reportFile string       Set mtk report file or dir. If it is a file, use the file directory. 
                                Default value is ./report
                                report directory format [./report/reportYYYYMMDDHHMISS] ./report/report20210101121314
      --schemas string          the Migrate schema,Separated by commas.(schema1,schema2,db1)
      --tableSkip stringArray   Define table split. Can be specified multiple times. 
                                format schema.tableName --tableSkip MTK.TABLE01 --tableSkip MTK.TABLE02
      --tables string           the Migrate tables,Separated by commas.(tab1,schema1.tab1)

SEE ALSO

  • mtk - Database Migration Toolkit
Copyright © 2011-2024 www.enmotech.com All rights reserved.