This article was originally published on May 25, 2023
WHAT’S NEW
This update is notifying you of the new software release of Migration Toolkit 55.6.0. The Migration Toolkit migrates data, tables, views, procedures, functions, packages, and other database objects from Oracle, MySQL, SQL Server, and Sybase to EDB Postgres Advanced Server (EPAS) and PostgreSQL.
Highlights of this release include the following:
Enhancements
- Migration Toolkit now provides two new command options to let you exclude a subset of objects during migration. The -excludeTables option skips a subset of tables when all tables are selected for migration, and the -excludeViews option skips a subset of views when all views are selected for migration.
Bug Fixes
- Fixed the issue where a data migration fails when Migration Toolkit attempts to drop a system generated index. Any system generated indexes are now skipped from removal. [Support ticket # 90282]
- Fixed the issue where a data migration fails with “Invalid LOB locator specified” error when migrating an Oracle table with an XMLTYPE column. [Support ticket # 92284]
- Fixed the issue where a TRUNCATE is always applied on the target database when performing a data only migration from SQL Server if the source table contains a LOB type column. This behavior is now corrected so that TRUNCATE will only be applied when the user has specified the -truncLoad option.
- Updated the Migration Toolkit packaging for Debian so that the JDBC drivers are no longer bundled with Migration Toolkit to make it consistent with the packaging for the other OS platforms supported by Migration Toolkit.
TELL ME MORE
For more information about the latest version of Migration Toolkit, please see the Migration Toolkit 55.6.0 documentation.
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in Postgres Enterprise Manager and have a subscription plan purchased for:
- Standard
- Enterprise
HOW TO GET THE SOFTWARE
Migration Toolkit is available from the EDB website https://www.enterprisedb.com/software-downloads-postgres#migration-toolkit
To request the credentials required to access EDB repositories, please visit https://www.enterprisedb.com/repos-downloads
TROUBLESHOOTING
If you experience any problems with the installation, migration, upgrade, or general use of your EDB software contact our Technical Support teams.
Customers can reach Technical Support through the EDB Customer Support Portal. We’re also available 24x7 via email and phone:
techsupport@enterprisedb.com
trial-help@enterprisedb.com
US: +1-732-331-1320 / 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612