Release Announcement Migration Toolkit 55.0.0

Highlights

Type

Table-level Parallel Data Loading

Migration Toolkit now supports parallel data loading at the table level. This allows you to use multiple threads to load data in parallel from the source database table and apply in parallel on the target database table. This significantly improves the data load time when dealing with relatively large size tables. The lab benchmark results have revealed a 25-60% reduction in the data load duration for a large table when using multiple parallel threads. This feature is supported for source PostgreSQL, EDB Postgres Advanced Server, and Oracle databases.

Enhancement

Addition of New Command-line Options

As part of the table-level parallel data loading enhancement, the following new options have been added to the MTK command-line options list:

• tableLoaderLimit
• parallelLoadRowLimit

Enhancement

Migration Support for Oracle 18c and 19c

Enablement of schema and data migration from Oracle versions 18c and 19c

Enhancement

Report total migration time (for schema and data migration)

Now total migration time for the migration session is reported via the “Total Elapsed Migration Time” attribute. 

Enhancement

Fixed the summary report to accurately report status when data migration fails for table(s)

Bug Fix

Fixed the summary report to remove redundant invalid objects

Bug Fix

Fixed a corner case where data size for a table was reported in exponential format

Bug Fix

Avoid failures when a duplicate table name is specified via '-tables' list 

Bug Fix

Reflect small table sizes that were previously displaying as 0.0 MB

Bug Fix