EnterpriseDB TECHNICAL ALERT Postgres Plus Advanced Server July 28, 2009 Migration ToolKit

A Technical Alert has been published and made available to all customers who have purchased a Subscription plan to Postgres Plus Advanced Server.

The Technical Alert archive file containing a description of the alert and the updated software is available at: http://www.enterprisedb.com/downloads/updates/MTKUpdate_Build_27-20090723.zip

Customers using the Advanced Server DBA Management Server will be notified automatically and also receive a Technical Alert email from EnterpriseDB shortly.

TECHNICAL ALERT STATUS
========================

Status: Recommended

Critical - this update fixes a possible data corruption, calculation, search set, or other function that may lead to inaccurate results. The update should be applied at the earliest possible time as it may affect a large number of users.

Recommended - this update fixes non-critical issues that may impede general usage and require undesirable work-arounds affecting a limited number of users. The update is recommended to be applied when convenient.

Informational - this update is informational only for non-critical issues. No software update or patch needs to be applied and issues may be addressed in the field using the specified version currently installed.

WHAT IS IN THIS ALERT
=====================
This Technical Alert is notifying you of a software update that addresses the Migration Toolkit module shipped with the GA version of Postgres Plus Advanced Server 8.3 R2 (8.3.0.106).

The software update contains the following fixes and enhancements:

1) Support for DEFAULT in List based partitions (12521)

Symptom: If an Oracle LIST based partition table had one of the partitions use DEFAULT in the VALUES clause (e.g. PARTITION part_others VALUES (DEFAULT)), the partition failed to migrate.
Fix: The MTK now handles the DEFAULT case for list partitions. All the DEFAULT case specific values are now directed to a default partition child table e.g. sample_part_others.
New Behavior: A LIST based partition table with partition based on DEFAULT clause migrates successfully.

2) Support for Index Organized Table (12573)

Symptom: Migration was not successful for a complete schema when one of the tables was an Indexed Organized Table.
Fix: The system generated table for an IOT table was not being filtered out, which is now corrected.
New Behavior: The migration is successful for schemas with IOT related system tables.

3) Support for public synonyms representing database links (11982)

Symptom: A public synonym representing a database link was skipped during migration.
Fix: The MTK is now enhanced to to support migration of synonyms created for a database link.
New Behavior: A public synonym created against a database link is migrated successfully.

4) Information regarding master DDL file in MTK readme (12343)

Symptom: The mtk-readme had no information for the offline migration enhancement to generate a single DDL file.
Fix: The mtk-readme guide has been updated to include the additional information related to master DDL file generation.
New Behavior: Users can refer to the updated mtk-readme to get information about the master DDL file.

5) Syntax error in VIEW DDL scripts (12342)

Symptom: The DDL script for offline migration threw a syntax error on execution against Postgres Plus Advanced Server if it contained VIEW objects.
Fix: Each of the DDL SQL statements needs to be terminated with a semi colon. The semi colon that was missing for VIEW DDL statements has now been added.
New Behavior: DDL scripts containing VIEW objects are executed successfully.

This update only replaces the Migration Toolkit jar file (Build 27). The core engine version remains 8.3.0.106.

IS THIS ALERT FOR ME?
====================
This alert is for customers using:

- Postgres Plus Advanced Server version: 8.3.0.106
- Migration Toolkit

HOW TO GET THE UPDATE
======================

This update is available through the Postgres Plus Advanced Server DBA Management Server. Click either the 'Check for Updates' link or the Elephant icon which should be colored Yellow indicating an update is available.

If you don't use the DBA Management Server, you may optionally download the update at the following URL:

http://www.enterprisedb.com/downloads/updates/MTKUpdate_Build_27-20090723.zip

HOW TO APPLY UPDATE
===================

Please perform the following steps in order to update your installation with the latest version of MigrationToolkit:

1) Unzip the file update_mtk_20090723.zip and copy it to the $EDB_HOME/updates directory

2) Run the script edb_update.sh/edb_update.bat from the update_mtk_20090723 directory

HOW TO RESTORE OLD VERSION
==========================

Please perform the following steps in order to restore your installation to the old version of MigrationToolkit:

1) Unzip the file $EDB_HOME/updates/update_mtk_20090723_restore.zip and copy it to the $EDB_HOME/updates directory

2) Run the script edb_restore.sh/edb_restore.bat from the update_mtk_20090723_restore directory

TROUBLESHOOTING
=================

If you experience any problems applying the upgrade or restoring the old version after applying the upgrade, please contact Technical Support at:

Email: support@enterprisedb.com
Phone: +1-732-331-1320 or 1-800-235-5891 (US Only)
Submit a Support ticket at: https://www.enterprisedb.com/myenterprisedb.do