This article was originally published on March 20, 2020
TECHNICAL UPDATE
EDB Migration Toolkit 53.0.1
EDB Migration Toolkit 53.0.1
WHAT’S NEW
Learn what’s new and fixed customer defects in EDB Migration Toolkit 53.0.1 product release. The tool migrates tables, views, procedures, functions, packages, and other database objects and data from Oracle, SQL Server, Sybase and MySQL to Postgres and EDB Advanced Server.
Highlight of this release:
| Feature | Benefit |
| SLES support: Starting this release, Migration Toolkit supports SUSE Linux Enterprise Server 2012 SP4 & SP5. | Now, Migration Toolkit can be installed on SUSE Linux Enterprise Server 2012 SP4 & SP5 as well. |
CUSTOMER DEFECTS FIXED
The following customer defects (in the context of xDB - Replication Server) are fixed in this release:
- PostgreSQL 9.6 or later to PostgreSQL 9.6 or later - An ERROR: unrecognized privilege type "unknown" shown by MTK and the table is partially migrated. [MTK 245 Support Ticket 940487]
- Advance Server 9.5.15.21 to Advance Server 9.5.15.21- Error when taking a snapshot in XDB for ARRAY datatypes [MTK 253 Support Ticket 964245]
IS THIS FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Migration Toolkit 53.0.1 and have a subscription for:
HOW TO GET THE SOFTWARE
You can use an RPM package or StackBuilder Plus to install Migration Toolkit. StackBuilder Plus is distributed with both Advanced Server and PostgreSQL one-click installer, available at EnterpriseDB.
Before installing Migration Toolkit, you must first install Java (version 1.7.0). Free downloads of Java installers and installation instructions are available at: http://www.java.com/en/download/index.jsp
You can use an RPM package or StackBuilder Plus to install Migration Toolkit. StackBuilder Plus is distributed with both Advanced Server and PostgreSQL one-click installer, available at EnterpriseDB.
Before installing Migration Toolkit, you must first install Java (version 1.7.0). Free downloads of Java installers and installation instructions are available at: http://www.java.com/en/download/index.jsp
- RPM package: For more information on installing MTK through RPMs, see Using an RPM Package to Install Migration Toolkit.
- StackBuilder Plus
Perform the following steps to update your Migration Toolkit for Postgres Plus Advanced Server. It is recommended that you back up your files before performing the upgrade.
1. Right-click on the System tray icon (PostgreSQL Elephant) and select Install Components. StackBuilder Plus will start and the available updates are displayed in bold in the component selection screen.
OR
Run StackBuilder Plus directly from the Application menu. The update will automatically be selected and displayed in bold.
2. Expand the Add-ons, tools and utilities node of the tree control, and check the box next to EnterpriseDB Migration Toolkit.
3. Click Next to continue.
4. Click Next and select the download directory (where the update will be downloaded).
5. The installation program will start once the download is complete.
Note: The data directory will not be affected by this upgrade.
For more information, see the EDB Postgres Migration Toolkit Guide:
1. Right-click on the System tray icon (PostgreSQL Elephant) and select Install Components. StackBuilder Plus will start and the available updates are displayed in bold in the component selection screen.
OR
Run StackBuilder Plus directly from the Application menu. The update will automatically be selected and displayed in bold.
2. Expand the Add-ons, tools and utilities node of the tree control, and check the box next to EnterpriseDB Migration Toolkit.
3. Click Next to continue.
4. Click Next and select the download directory (where the update will be downloaded).
5. The installation program will start once the download is complete.
Note: The data directory will not be affected by this upgrade.
For more information, see the EDB Postgres Migration Toolkit Guide:
HOW TO RESTORE TO ORIGINAL VERSION
In order to restore to the previous version, run the previous version installer. This will restore the migration toolkit to the previously installed version.
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