HomeMogDBMogDB StackUqbar

Documentation:v2.0

Supported Versions:

mtk mig-select

migrate custom query statements to csv or target table

Synopsis

migrate custom query statements to csv or target table

mtk mig-select [flags]

Examples

# mig select statements to csv
./mtk -c mtk.json mig-select --sql "select 1 as col1,sysdate as col2, 'aaa' as col3 from dual"

# mig select statements to table
./mtk -c mtk.json mig-select --sql "select 1 as col1,sysdate as col2, 'aaa' as col3 from dual" --tabName schema1.table1

# colName with spaces,tab, NBSP(Non-Breaking Space)
./mkt -c mtk.json mig-select --sql 'select "ID" AS "ID","ID1" AS "ID1"," COL1 " AS " COL1","    COL2    " AS "    COL2",
                "    COL 3    " AS "    COL 3","    KEY_RECNO            " AS "    KEY_RECNO" FROM MTK1."TEST_TABLE_2020415 "'

Options

  -h, --help             help for mig-select
      --sql string       specifies the query statement
  -t, --tabName string   specifies table name

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.