Supported platforms and databases v55

All the PostgreSQL and EDB Postgres Advanced Server versions available as EDB Postgres AI Cloud Service single-node, primary/standby high-availability, and distributed high-availability cluster types are also supported for use with Migration Toolkit. See the Cloud Service documentation for more information about Cloud Service’s supported cluster types. See the database version policy documentation for the versions of PostgreSQL and EDB Postgres Advanced Server available in Cloud Service.

The superuser role isn't available in EDB Postgres AI Cloud Service EDB Postgres Advanced Server distributed high-availability cluster databases. As a result, the following Migration Toolkit capabilities that require superuser access aren't supported when targeting Cloud Service distributed high-availability clusters:

• The -copyViaDBLinkOra option that enables data migration using the db_link_ora extension
• The Oracle-compatible SQL command CREATE DATABASE LINK

The Migration Toolkit isn't tested with and doesn't officially support use with Oracle Real Application Clusters (RAC) and Exadata. However, Migration Toolkit might work when it's connected to a single persistent node. For more information, contact your EDB representative.

The ojdbc7.jar can cause large data migrations to be incomplete due to a limit on records over Integer.MAX_VALUE (2147483647) while fetching from the ResultSet. To avoid this issue, we recommend upgrading to ojdbc8.jar.