This article was originally published on November 23, 2018
TECHNICAL UPDATEEDB Migration ToolkitⓇ 52.0.0
WHAT’S NEW
This update is notifying you of a new software release EDB Migration Toolkit Ⓡ 52.0.0. The tool migrates tables, data, stored procedures (Oracle only) and custom developed packages (Oracle only) from SQL Server, Sybase, Oracle and MySQL to EDB Advanced Server. More limited capabilities are available for migrations to PostgreSQL.
Highlights of this release include:
- Migration Toolkit now supports PostgreSQL 11 and EDB Postgres Advanced Server 11
- Oracle to EPAS
- While using MTK, if one of the columns contains escape characters, an issue occurs. [Support Ticket #750646, MTK-104]
- While using MTK with Advanced Server 10, foreign key constraints are not supported on partitioned table. [Support Ticket #752434, MTK-105]
- While migrating AFTER LOGIN TRIGGER, a NullPointerException occurs. [Support Ticket #774222, MTK-111]
- While migrating database using MTK offline tool, the migration script generates an invalid DDL statement for timestamp column. [Support Ticket #773504, MTK-114]
- While migrating database, if you use –useOraCase option, the NullPointerException error occurs. [Support Ticket #815544, MTK-139]
- SQL Server 2008 to EPAS
- While migrating database, the -skipColDefaultClause option is not supported. [Support Ticket #773813, MTK-113]
- PostgreSQL to EPAS
- While migrating database, the sequence order in not synced and the following error message is displayed: duplicate key violates unique constraints. [Support Ticket #786667, MTK-115]
- While migrating VIEWS that have names in upper and lower cases, the names are stored in lower case. [Support Ticket #788302, MTK-117]
- EPAS to PostgreSQL
- While migrating database that contains the Composite Foreign Key Index, a NullPointerException occurs. [Support Ticket #790408, MTK-116]
KNOWN ISSUES
- Procedures from PostgreSQL are being migrated as functions in EPAS [MTK-142]
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Migration Toolkit 52.0.0 and have a database subscription purchased for:
- EDB Postgres Standard Edition
- EDB Postgres Enterprise Edition
HOW TO GET THE SOFTWARE
This update is available from the EDB Postgres website https://enterprisedb.com/advanced-downloads or via Stack Builder Plus for Windows ONLY.
This update is also available as an RPM package that can be downloaded from the yum.enterprisedb.com repository. To setup your credentials and gain access to the yum repository, please submit a request: https://www.enterprisedb.com/repository-access-request
For more information, see the EDB Postgres Migration Toolkit Guide
TROUBLESHOOTING
If you experience any problems installing the new software please contact Technical Support at:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612