v2.0
- Overview
- Environment
- Quick Start
- Configuration
- Commands
- mtk
- init-project
- config
- license
- mig
- show
- sync
- sync-schema
- sync-sequence
- sync-object-type
- sync-domain
- sync-wrapper
- sync-server
- sync-user-mapping
- sync-queue
- sync-table
- sync-nickname
- sync-rule
- sync-table-data
- sync-table-data-estimate
- sync-index
- sync-constraint
- sync-db-link
- sync-view
- sync-mview
- sync-function
- sync-procedure
- sync-package
- sync-trigger
- sync-synonym
- sync-table-data-com
- sync-alter-sequence
- sync-coll-statistics
- check-table-data
- gen
- gen completion
- encrypt
- convert-plsql
- report
- self
- mvd
- usql
- Graphical
- Faqs
- Release
Release 2.5 Notes
v2.5.2
Bug Fixes
- DB2:
syscat.Columns
view with table name suffix and space problem - MySQL: Remove connection parameter
explicit_defaults_for_timestamp
when MySQL is source database - MySQL: Migration
id BIGINT(20) unsigned AUTO_INCREMENT
to sequence issue - MySQL: Migration
id INT(10) unsigned AUTO_INCREMENT
to sequence issue - MySQL: Query constraint SQL add
binary
keyword - MySQL: Migration MySQL
Time
type column default value problem - openGauss: Query partition syntax issue when partition name is numeric
Code Refactoring
- MTKD: Update
supportOperate
API return data structure - MTKD: Update
convertSQLSupportType
API
Features
- MTK: Add parameter
charLengthChangeExclude
- MTK: Query Oracle NLS related parameters and save to
otherParams
- MTK: Add
mig-selects
subcommand - MTKD: Add task
getSchemas
API - MTKD: Add operate API
- MTKD: Add merge task running record function
- SQLServer: Supports partial function/procedure syntax conversion to openGauss (beta)
- SQLServer: Supports query functions/procedures
- SQLServer: Supports query triggers
v2.5.1
Bug Fixes
- DB2: Rewrite
insert into table_name values
error problem - MTKD: Typo SUCCESS -> Succeed
- Oracle: Query Oracle Package issues
Code Refactoring
- MTKD: Optimize DB2 query table information statement
Features
- MTK: Add
convertOracleIntegerToNumeric
parameter - MTK:
excludeTable
adds regular expression support - MTK:
mig-tab-data
/sync-table-data
addtableSplit
parameter - MTK: Add
convert-plsql
/report-to-sql
command - MTKD: Add
errorDataFile
api
v2.5.0
2022-08-14
Bug Fixes
- DB2: Migration DB2 view syntax conversion related issues
- MTK: fix ColumnType null pointer problem
- MTK: add invalid information prompt for invalid objects
- MySQL:
DEFAULT_GENERATED ON UPDATE CURRENT_TIMESTAMP
syntax issue - Oracle: ignore
IOT_OVERFLOW
table - Oracle: syntax conversion
AQ$_CBSD_CHREXX
problem - Oracle: VARRAY Type and type varchar2(10 char)
- Oracle: changed to
PIPE ROW
toreturn next ();
- Oracle: changed to Oracle
SYS_EXTRACT_UTC
problem - openGauss: left join alias problem and judging stored procedure error problem
Code Refactoring
- MTK: add character set definition
- Oracle:
authid current_user
syntax adaptation - RDBMS: SetConnMaxLifetime to SetConnMaxIdleTime
Features
- MTK: Add Excel report
- MTK: add
convert-plsql
subcommand - MTK:
report-to-sql
subcommand adds the function of converting HTML reports to Excel reports - MTKD: Added report and log download, conversion SQL, system information API
- Oracle: query view/function/procedure object ID
- Oracle: Rewrite Oracle
commit work
to openGausscommit
- openGauss: migrates Oracle Package to openGauss 3.0 Package by default
Performance Improvements
- Oracle: Optimize query view performance