Notice: The names for EDB™’s products have changed. The product formerly referred to as Postgres Plus Advanced Server is now referred to as EDB Postgres™ Advanced Server. Until a new version of this documentation is published, wherever you see Postgres Plus Advanced Server you may substitute it with EDB Postgres Advanced Server. Name changes in software and software outputs will be phased in over time.EDB Postgres Migration Toolkit (Migration Toolkit) is a powerful command-line tool that offers granular control of the migration process. Migration Toolkit facilitates migration of database objects and data to an Advanced Server or PostgreSQL database from:
• You can also use Migration Toolkit to migrate database objects and data from Sybase to Advanced Server, or between Advanced Server and PostgreSQL.You can install Migration Toolkit with the EDB Postgres Advanced Server installer, or via Stack Builder. Stack Builder is distributed with both the Advanced Server, and the PostgreSQL one-click installer available from the EnterpriseDB web site at:This guide provides a high-level description of the steps involved in the migration process, as well as installation and usage instructions for Migration Toolkit. It also includes solutions to common migration problems, and details unsupported features and their potential workarounds.This guide uses the term Postgres to refer to either an installation of EDB Postgres Advanced Server or PostgreSQL.This guide uses the term Stack Builder to refer to either StackBuilder Plus (distributed with EDB Postgres Advanced Server) or Stack Builder (distributed with the PostgreSQL one-click installer from EnterpriseDB).EnterpriseDB does not support the use of Migration Toolkit with Oracle Real Application Clusters (RAC) and Oracle Exadata; the aforementioned Oracle products have not been evaluated nor certified with this EnterpriseDB product.