Release 2.8 Notes

mtk command line tool
mtkd mtk background service process. used for specific scenarios

v2.8.5

2023-04-24

MTK

MTKD

Bug Fixes

MTK: Command flag disableCollStatistics does not work issue
MTK: The parameter channelCacheNum is too large
MTK: Migrate Oracle character set ZHS16GBK database clientCharset issue
MTKD: PreCkeck recognizes the problem of not logging error messages to the database
MTKD: Modify table structure Mediumtext to MediumBlob
MogDB: Rewrite NUMTOYMINTERVAL(1,'MONTH') problem
MySQL: MySQL STORED GENERATED problem
Oracle: Query Oracle Xmltype error ORA-19011 problem
Oracle: A table has the same index name under two users
Report: The Excel report lost the number of failures

Features

MTK: Command flag override configuration file parameters problem
MogDB: Create View/function/procedure Warn if object exists modified
MogDB: Support uint1/uint2/uint4/uint8 column types
MogDB: Adapted to Dolphin plug-in, first created with original SQL, rewritten after failure
MySQL: Reacquire the connection before inserting data
Oracle: Support generating bitmap join index syntax
Oracle: Query DBLink synonyms
Oracle: Adapted to 9.2.0.4

v2.8.4

2023-04-03

MTK

MTKD

Bug Fixes

Config: Add check channelCacheNum value is too large to cause OOM issue
DB2: Migrating DB2 GBK to openGauss GBK issue
MTK: table/column name keywords add = to match
MTK: Rewrite trigger UPDATING('salary') syntax issue
MTKD: StartOperate/update interface merge config issue
MTKD: asynchronous refresh task status storage issue
MTKD: concurrent migration DB2 setting codepage issue
MTKD: stop task without updating the task details issue
MTKD: optimization run log
MTKD: concurrent migration blob to bytea/blob issue
MVD: Pass license file to mvd issue
MVD: Parse MVD version issues
MogDB: Add rewrite function without parentheses call issue
MogDB: Rewrite varchar(100CHAR) issue
MogDB: Rewrite DBMS_OUTPUT.PUT_LINE issue
MogDB: Rewrite column default ('now'::text)::timestamp(3) issue
MogDB: Rewrite OUTERJOIN Issue
MogDB: Rewrite insert /*+ append */ into table alias issue
MogDB: Synchronize Oracle sequence as Large sequence issue
MySQL: Migrate bit(0) issue
MySQL: ignoring create constraint 1061 (HY000): Duplicate key name error
MySQL: Rewrite to_char issue
MySQL: Migrate bigint|int UNSIGNED issue
PLSQL: Extract comment issue
PLSQL: Extract constant issue
PLSQL: Rewrite insert into grammar loss comment issue
PLSQL: Rewrite insert into comment table alias(column) values issue

Features

MTK: convert-plsql supports defining SQL statement delimiters
MTK: show-drop-cons supports generating disable constraint statements
MTK: Add parameter ColumnTypeData
MTK: Add parameter skipExistPLSQL
MogDB: Ignore create package header already exists error
MogDB: Disable rewrite listagg syntax for mogdb 3.0.0
Oracle: Query Oracle type/table/cons/view add hint syntax
openGauss: openGauss 2.0.0 copy syntax does not support TRANSFORM syntax issue

v2.8.3

2023-02-23

MTK

MTKD

Bug Fixes

DB2: optimize timestamp generate column migration MogDB logic
DB2: Fix CLI0129E An attempt to allocate a handle failed problem
MTK: The SCN specified in the configuration file does not take effect
MogDB: Create a partitioned index syntax under the specified index option
MogDB: Migrating DB2 GBK to MogDB GBK problem
MogDB: Adjust the package creation transaction, not in the transaction
MogDB: Rewrite insert into xxx nologging syntax
MogDB: Rewrite function without parentheses problem
MogDB: Remove override x = null
PLSQL: Extract comment questions in PLSQL
PLSQL: Rewrite comments to include constant issues

Code Refactoring

MogDB: Optimize constraint renaming logic

Features

MTK: SQL statement error information is not recorded after configuring igErrorData
MTKD: Add download report does not contain error data interface
MogDB: override MySQL Create table like table syntax
MogDB: Add GB18030 character set
MogDB: Rewrite Oracle create type force syntax

Performance Improvements

MTKD: Optimize asynchronous insert database performance

v2.8.2

2023-02-23

MTK

MTKD

Bug Fixes

MTK: Migrating MySQL to MySQL records ignores the inaccurate number of rows - MTK: Unenforces object client encoding issues
MTK: mig-select trim the end of SQL statement ;

Features

MTK: Support for MySQL 'LINEAR HASH/KEY' partitions
MTKD: Check for tasks that did not stop gracefully on startup and stop

v2.8.1

2023-02-20

MTK

MTKD

Bug Fixes

MTK: Upgrade download DB2 package issue
MTK: Set cache queue to 1000 for BLOB
MTKD: license gen issue
MogDB: Migration Oracle package DETERMINISTIC problem
MogDB: Migration Oracle function return xx -- comment problem
MogDB: Remove auto alias function
MySQL: Supports MySQL Collation (Database/Table/Column)

Features

MTK: Add parameter customFuncTrans
MTK: Add parameter ColumnNameData
MTK: modify parameter channelCacheNum default value is twice of fetchSize
MTKD: Add /docs/mtk-parameter-desc interface
MTKD: Add taskRunInfoMen interface
MogDB: Rewrite Oracle update|delete return into to update|delete return into
MogDB: Rewrite Oracle unpaired block comment /* /* /* issues
MySQL: Hide migration MySQL to MySQL sequence

v2.8.0

2023-02-06

MTK

MTKD

Bug Fixes

MTK: Set the table status to failed when the number of ignored rows in the report is equal to the number of query rows
MTK: Exporting to a file is a time loss time zone issue
MogDB: Migrate Oracle BC time issue
MogDB: Migrate DB2 auto-increment column ALTER [LARGE] SEQUENCE OWNER issue
Oracle: Migrate Oracle COL_XMLTYPE SYS.XMLTYPE column type issue
Oracle: Migrate MogDB to Oracle partition table issue
Oracle: Migrate MogDB to Oracle field length is greater than 4000 issue
Oracle: Insert Oracle data issue
Oracle: When pureDriver = true query Oracle Number(38,128) data issue
openGauss: Rewrite insert statement table alias issue

Features

DB2: Migrate DB2 float to MogDB real, double to MogDB double precision
MTK: Simplify the default output parameter list, add --detail to output all parameters
MTKD: Supports calling MVD for data comparison
MogDB: Migrate Oracle binary_float to MogDB real, binary_double to MogDB double precision
MogDB: Add the parameter replaceBCDate to support rewriting the 4173 time data before the park
MogDB: Check creation constraints and index error messages, if the object name already exists, mark it as a warning
MogDB: Migrate Oracle to MogDB/openGauss loses virtual column syntax
MogDB: added parameter ignoreTabPartitionTabList
MogDB: noSupportPartTabToNormalTab add partition key for virtual column check
MogDB: override DB2 timestamp column default value DEFAULT "SYSIBM"."TIMESTAMP"(CURRENT TIMESTAMP)
MogDB: Supporte MogDB 3.1.0 set column type
MySQL: Modify the auto-increment column PK_ID column, the primary key is the only key for autoAddMySQLAutoIncr
openGauss: ignoreTabPartition supports all databases