cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Update for EDB Migration ToolkitⓇ 52.0.0

 

Technical Alert/Update Information

 

Technical Alert Name
EDB Technical Update for Migration ToolkitⓇ 52.0.0
Product Type
Others
Release Date
11/23/2018
Technical Alert Details
TECHNICAL UPDATE
EDB 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
Customer Bugs Resolved:
  • 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
Version history
Revision #:
1 of 1
Last update:
2 weeks ago
Updated by:
 
Labels (2)
Contributors