HomeMogDBMogDB StackUqbar
Ecological Tools
Doc Tools
中文
v2.0

Documentation:v2.0

Supported Versions:
Current(v2.0)

Release Note

v1.11.3(2024.05.21)

Bug Fixes

  • Updated the dependency component vulnerability scan results to fix various risk vulnerabilities scanned

v1.11.2(2024.01.30)

Bug Fixes

  • Fixed the number of missing records for full synchronization between Oracle and MogDB
  • Fixed missing constraint columns in MySQL to MogDB composite constraint structure synchronization
  • Fixed the problem that the source node is MogDB and the mapping of blob and clob types is missing
  • Fixed MogDB to MySQL structure synchronization, time type missing precision issues

v1.11.1(2023.12.21)

Bug Fixes

  • Optimize add object page interaction
  • Fixed the lack of advanced parameters after MogDB to Oracle channel upgrade

v1.11.0(2023.12.15)

Features

  • Added the custom fragmentation function to manually fragment Oracle tables in parallel and fully synchronize some data
  • Support Oracle/MogDB data validation by invoking the new data validation module through MDB
  • Supports Oracle/MogDB data verification in dynamic scenarios
  • Added data merge function before data delivery to optimize merge processing for the same recorded data
  • Added global exception recognition on the delivery side and prompt an exception after the delivery of a regular state
  • Added the strict data synchronization mode switch to ensure the consistency of modifying and deleting tables without primary keys
  • Select the task phase when creating a channel. You can create a synchronous channel with only full migration

Bug Fixes

  • Fixed data loss from Oracle database to MogDB in TPCC scenarios
  • Fix Oracle to MogDB GBK character set garbled characters
  • Fixed an error when MogDB failed to add objects to MySQL and field data was obtained

v1.10.1(2023.11.16)

Bug Fixes

  • Fixed 1.10.0 Upgrade failure due to unlisted names in upgrade script
  • Fix missing parentheses for MogDB to Oracle structure synchronization default conversion
  • Fixed an issue where incremental delivery was not notified when no data tables existed in Oralce full synchronization

v1.10.0(2023.11.10)

Features

  • Reconfiguration optimizes the full data synchronization logic from Oracle to MogDB, increasing efficiency by more than 10 times
  • ADAPTS to the B-mode database enabled by the Dolphin plug-in, improving the compatibility of MySQL to MogDB for structural synchronization
  • Automatically identifies Service/SID categories when Oracle nodes are added or modified, improving product usability
  • Added detection of unsupported tables, unsupported fields, and warning prompts in the pre-check phase
  • Optimize database detection logic during compatibility analysis and add database data deletion logic
  • Adjust the page sort field, support custom table header sort the entire table content
  • Support MySQL Linar partition category, automatically converted to Hash partition
  • Added automated identification and support for Oracle virtual column partitioning keys
  • Enhanced support for MySQL key partitions. key partitions without specified field information are supported
  • Optimizes the channel creation time point selection list, provides aggregation by library type and search by keyword
  • Support for MogDB to MogDB structure and data synchronization (full and incremental)
  • Supports full and incremental data synchronization from MogDB to DB2
  • Optimize the contrast display of SQL rewriting pages before and after rewriting, providing a variety of display styles to choose from
  • Supports automatic rewriting when other libraries synchronize to MogDB and the column name coincides with the hidden column of MogDB

v1.7.3(2023.09.05)

Bug Fixes

  • Fixed an issue that Oracle19c synchronizes data to MogDB, but full data is not synchronized in PDB mode
  • Fixed an issue that the synchronized data record was not displayed after data synchronization in datahub and kafka

v1.7.2(2023.07.26)

Bug Fixes

  • Modifies the datahub output format
  • Fixed an issue where datahub output was not decrypted

v1.7.1(2023.07.07)

Bug Fixes

  • Added database user sysadmin permission check

v1.7.0(2023.07.03)

Features

  • New home page to provide a summary of basic information, as well as different dimensions of each channel monitoring display
  • Reconstruct the object import function, providing an independent page to record the excel/csv data import list and details, and providing a list and export of failed objects
  • Optimized operation logic. Some manual operations can be automatically performed, such as data clearing after data synchronization reset and enabling supplementary logs during pre-check
  • Added the long transaction check function before data synchronization. Before data synchronization, the Oracle source check whether there are long transactions exceeding UNDO_RETENTION and provide a warning and detailed session information on the page
  • Optimizes the permission detection logic during SCA initialization and analysis, and optimizes the compatibility analysis list sorting rules
  • Scenario optimization: Supports synchronization scenarios in which indexes with the same name are created for different users of an Oracle table

Bug Fixes

  • Check before data synchronization prompts optimization
  • Fixed table synchronization status not updated after delivery exception

v1.6.2(2023.06.16)

Bug Fixes

  • SQL contrast removes default formatting
  • Fixed NOT NULL constraint query error.
  • Fixed an error in querying constraint DDL in MogDB/POSTGRESQL
  • Fixed an error in deleting TABLE DDL statement in Oracle

v1.6.1(2023.06.09)

Bug Fixes

  • Fixed missing database script column names
  • Fixed an issue where columns in constraint expressions of type check were not handled correctly
  • Fixed an issue where constraint name case conversion was not handled correctly

v1.6.0(2023.06.07)

Features

  • SQL rewriting page adjustment, support the SQL before and after rewriting difference comparison, easy to quickly locate the change point
  • Supports the MogDB parallel parsing function. In versions later than 3.0, the parallel parsing feature can be enabled to improve the logical parsing efficiency
  • Supports the adaptation of scenarios where constant values exist in Oracle index fields
  • In the data synchronization details, you can directly skip data synchronization (full or incremental), and add the condition filtering of whether to skip data synchronization in the object list table
  • Add the MDB monitoring page in the channel, which can monitor the delay of data synchronization, the amount of DML changes, and some indicators of Kafka
  • Added the ability to regularly synchronize the latest values of the sequence (supported database types: MogDB, Oracle, MySQL, PG), the sequence value synchronization details can be seen on the Data synchronization details page
  • Support table level status and SCN function transformation, for the subsequent dynamic addition and deletion of tables to do basic transformation
  • Data synchronization for Oracle CLOBs and BLOBs is supported

Bug Fixes

  • Fixed MDB channel status not automatically refreshing
  • Fixed an issue where SCHEMA overlay schema was forcibly deleted

v1.5.4(2023.05.31)

Bug Fixes

  • Rectify the inconsistency between the full and incremental synchronization details and the channel status
  • Fixed SCHEMA synchronization failure from MogDB to MySQL overlay mode
  • Fixed repeated creation of synchronization constraints from MySQL to MogDB

v1.5.3(2023.05.17)

Bug Fixes

  • Fix the problem that the new object has no data when the channel contains kafka and datahub nodes

v1.5.2(2023.05.16)

Bug Fixes

  • Fixed target database trigger check, disable trigger error
  • Fixed data delivery, update/delete error without primary key

v1.5.1(2023.05.08)

Bug Fixes

  • Fixed import object error tip
  • Fixed the MDB parameter in the advanced configuration of the node, and the connection character set is compatible with the old data

v1.5.0(2023.05.06)

Features

  • Supports MogDB to DB2 data synchronization
  • Supports MogDB to MySQL object synchronization
  • The failure to synchronize non-table objects does not affect data synchronization
  • Supports the specified MogDB connection character set to implement UTF8/GBK character set data migration and conversion in Oracle/MogDB database
  • Before object synchronization, the system obtains structure information from the source database in real time
  • Verify objects before data synchronization

Bug Fixes

  • Fixed data extraction service status display issues

v1.4.3(2023.05.05)

Bug Fixes

  • Fixed database version parsing error

v1.4.2(2023.04.18)

Bug Fixes

  • Fixed the interface on the compatibility analysis page is lost

v1.4.1(2023.04.11)

Features

  • When synchronizing to the datahub, change the created topic to the tuple type

Bug Fixes

  • Rectify the error of the log extraction and log delivery request interface
  • Fixed object list field display issues
  • Rectify a data synchronization error after data synchronization fails

v1.4.0(2023.03.31)

Features

  • Supports user-defined MogDB replication ports. Supports automatic or manual adjustment of MogDB replication ports when thread pools are enabled
  • Interconnects with MTK, supports SQL statement rewriting and conversion of some databases, provides richer object synchronization and supports synchronization of more objects (Note: object synchronization failure will affect data synchronization, which needs to be handled manually)
  • Integrate the Oracle compatibility evaluation function of SCA to provide one-click automatic collection and analysis, and upload analysis after manual collection
  • Supports object synchronization from MogDB to ORACLE
  • The extraction/delivery process is split, and the logs of both are split at the same time. The channel state is more detailed and specific
  • Supports Kafka data compression

v1.3.2(2023.03.20)

Bug Fixes

  • Fixed data delivery failure caused by a database connection error when ORACLE was the target
  • Fixed data comparison parsing failure when ORACLE CDB is enabled

v1.3.1(2023.03.08)

Bug Fixes

  • Fixed full/incremental parameter value passing error in MDB version updater

v1.3.0(2023.02.24)

Features

  • ORACLE adds the ability to specify SCN when synchronizing data for sources
  • Migration objects can optionally filter SCHEMA level migrations
  • Page support for querying authorization information
  • Support importing objects that need to be synchronized via EXCEL
  • Add LOGMINER related parameters to advanced parameters when ORACLE synchronizes data for sources
  • Data synchronization can optionally skip the full and incremental data of an object

Bug Fixes

  • Fixed an issue where the executing channel could not be operated after MDB restarts the service
  • Fixed CST time zone precheck failure
  • Channel status still returns "data in sync" after fixing data extraction exceptions

v1.2.1(2023.01.30)

Bug Fixes

  • Fixed an error that occurred when MDB object synchronization failed to record the wrong data
  • Fixed ORACLE data synchronization scn pointing too old
  • Fixed failed data details page display

v1.2.0(2023.01.13)

Features

  • Supports data delivery to DATA_HUB and KAFKA
  • Discard or retry failed data on the interface
  • Added database version verification
  • Integrate MVD for data comparison
  • If MOGDB/PG is the source, the REPLICA IDENTITY FULL is not required for the primary key table

Bug Fixes

  • Fixed time type synchronization errors that did not include time zones
  • Fixed an issue where command line tools could only execute in the current path

v1.1.6(2023.01.09)

Bug Fixes

  • Fixed MDB synchronization object synchronization with foreign keys failed and was not logged

v1.1.5(2022.12.27)

Bug Fixes

  • Fixed the issue that the MDB does not authenticate the license of common products
  • Fixed time formatting issues
  • The command for copying license files is changed

v1.1.4(2022.12.20)

Bug Fixes

  • Fixed an issue where the 0x00 special character caused data not to be inserted in PG/MOGDB/OPENGAUSS

v1.1.3(2022.12.13)

Bug Fixes

  • Fixed precision loss of numeric type data.
  • Fixed MOGDB adding objects without properly handling constraints and indexes.
  • Fixed license don't general purpose.

v1.1.2(2022.12.09)

Bug Fixes

  • Fixed time zone and character set checking errors in MySQL to MogDB pre-check.

v1.1.1(2022.12.06)

Bug Fixes

  • Fixed the error of query index in MYSQL5.7 environment.
  • Fixed bug checking errors from MOGDB to MYSQL environment.

v1.1.0(2022.11.30)

Features

  • Support object synchronization from SQL Server to MogDB (schema,table).
  • Support object synchronization from SQL Server to MogDB for customized name mapping
  • Support full data synchronization and incremental data synchronization from SQL Server to MogDB.
  • Support incremental data synchronization pausing and continuing from SQL Server to MogDB.
  • Support full data synchronization and incremental data synchronization from MogDB to Oracle.
  • Support incremental data synchronization pausing and continuing from MogDB to Oracle.
  • Support full data synchronization and incremental data synchronization from MogDB to MySQL.
  • Support incremental data synchronization pausing and continuing from MogDB to MySQL.
  • Support full data synchronization and incremental data synchronization from MogDB to PostgreSQL.
  • Support incremental data synchronization pausing and continuing from MogDB to PostgreSQL.
  • Support full data synchronization and incremental data synchronization from MogDB to SQL Server.
  • Support incremental data synchronization pausing and continuing from MogDB to SQL Server.
  • Node Password encryption.
  • Object selection optimization.
  • Added the functions of manually adding objects and data synchronization reset.
  • Added temporary file configuration to the command line tool.

Bug Fixes

  • Fixed time-dependent data delivery exceptions.
  • Fixed object selection causing the browser to be unresponsive.
  • Fixed delivery SQL statement assembly errors.
  • Fix for mistakenly deleting a user's existing SLOT when PG/MOGDB is the source.
  • Fixed an issue with data saving missing fields after a failed delivery.
  • Fixed the incorrect column length after ORACLE ROWID type was migrated to MOGDB.
  • Fixed object column name mapping name error.
  • Fixed the data synchronization details sorting error.

v1.0.5(2022.11.03)

Bug Fixes

  • Fix datetime data type synchronization error.

v1.0.4 (2022.10.30)

Features

  • Support object synchronization from PostgreSQL to MogDB (schema,table).
  • Support object synchronization from PostgreSQL to MogDB for customized name mapping
  • Support full data synchronization and incremental data synchronization from PostgreSQL to MogDB.
  • Support incremental data synchronization pausing and continuing from PostgreSQL to MogDB.
  • Channel Data synchronization and incremental tracking are combined, and channel status is adjusted.
  • Added the status of the data Capture and Integrate services and the abnormal data synchronization status.
  • Supports synchronous recovery of abnormal data.
  • Optimized the way the command line tool checks the survival status of subservices.

Bug Fixes

  • Resolve the issue the scenario where the same table name in different schemas lead to objects synchronization fails.
  • Resolve the issue that the Connector connect is not exist lead to a channel pause failure.

v1.0.3 (2022.9.23)

Features

  • Support Oracle character set: ZHS16GBK
  • Add dump command, start and stop child service command.

Bug Fixes

  • Resolve the issue the scenario where the schema name or database name contains '#' lead to data synchronization fails
  • Resolve the issue that the heartbeat table is not filtered when the heartbeat table is enabled.

v1.0.2(2022.9.15)

Features

  • Support object synchronization from MySQL to MogDB (schema,table).
  • Support object synchronization from MySQL to MogDB for customized name mapping
  • Support full data synchronization and incremental data synchronization from MySQL to MogDB.
  • Support incremental data synchronization pausing and continuing from MySQL to MogDB.
  • Support Oracle CDB-PDB mode.
  • Add details about the channel synchronization task.
  • Changing the login URL.

v1.0.1 (2022.8.31)

Features

Bug Fixes

  • Resolve the issue that the snapshot data synchronization is completed, and the data synchronization task status is still "In progress"

v1.0.0 (2022.6.30)

Features

  • Support object synchronization from Oracle to MogDB (schema,table).
  • Support object synchronization from Oracle to MogDB for customized name mapping
  • Support full data synchronization and incremental data synchronization from Oracle to MogDB.
  • Support incremental data synchronization pausing and continuing from Oracle to MogDB.
  • Support MDB access from a browser for graphical operations.
HOME

Issue
Copyright © 2011-2025 www.enmotech.com All rights reserved.