Migration Toolkit

Migration Toolkit is a powerful command-line tool that offers granular control of the migration process. Migration Toolkit helps with migrating database objects and data to an EDB Postgres Advanced Server or PostgreSQL database from:

• Oracle
  

• MySQL
  

• Microsoft SQL Server
  

You can also use Migration Toolkit to migrate database objects and data from Sybase Adaptive Server Enterprise to EDB Postgres Advanced Server or between EDB Postgres Advanced Server and PostgreSQL.

You can install Migration Toolkit with the EDB Postgres Advanced Server installer or by using Stack Builder. Stack Builder is distributed with both the EDB Postgres Advanced Server and the PostgreSQL one-click installer available from the EnterpriseDB website.

!!! Note * The term Postgres in this documentation refers to either an installation of EDB Postgres Advanced Server or PostgreSQL. The term Stack Builder refers to either StackBuilder Plus (distributed with EDB Postgres Advanced Server) or Stack Builder (distributed with the PostgreSQL one-click installer from EnterpriseDB).

• Supported operating systems and database versions
  • Database versions
  • Supported operating systems versions
• Migration methodology
  • The migration process
  • Connecting an application to Postgres
• Functionality overview
  • Object migration support
  • Online migration versus offline migration
• Installing Migration Toolkit
  • Installing Migration Toolkit on a CentOS or RHEL 7 and 8 Host
    • Upgrading an RPM Installation
  • Installing Migration Toolkit on a CentOS, or RHEL 7 ppc64le Host
  • Installing Migration Toolkit on a Debian or Ubuntu Host
  • Installing Migration Toolkit on a SLES Host
  • Installing Migration Toolkit on Windows
  • Installing Migration Toolkit on Mac OS X
  • Installing Source-Specific Drivers
• Building the toolkit.properties file
  • Defining an Advanced Server URL
  • Defining a PostgreSQL URL
  • Defining a BigAnimal URL
  • Defining an Oracle URL
  • Defining a MySQL URL
  • Defining a Sybase URL
  • Defining a SQL Server URL
• Invoking Migration Toolkit
  • Importing character data with embedded binary zeros (NULL characters)
  • Migrating a schema from Oracle
  • Migrating from a non-Oracle source database
• Migration Toolkit command options
  • Offline migration options
    • Executing offline migration scripts
  • Import options
  • Schema creation options
  • Schema object selection options
  • Migration options
  • Migration options for parallel data loading
    • High-level overview of the parallel data-loading algorithm
    • System resource recommendations and constraints**
  • Oracle-specific options
  • Miscellaneous options
  • Example
• Migration errors
  • Connection errors
    • Invalid username/password
    • Connection rejected: FATAL: password
    • Exception: ORA-28000: the account is locked
    • Exception: oracle.jdbc.driver.OracleDriver
    • I/O exception: The Network Adapter could not establish the connection
    • Exception: The URL specified for the “target” database is invalid
  • Migration errors
    • ERROR: Extra data after last expected column
    • Error loading data into table: TABLE_NAME
    • Error creating constraint CONS_NAME_FK
    • Error Loading Data into Table
• Error codes
  • Error code summary
    • Class 02 - Warning
    • Class 10 - Invalid user input
    • Class 11 - Configuration issues
    • Class 12 - Insufficient privileges
    • Class 13 - Unsupported features
    • Class 14 - Missing objects
    • Class 15 - Schema migration
    • Class 16 - Procedural language migration
    • Class 17 - Data loading
• Unsupported features
  • Unsupported Postgres features
  • Frequently asked questions
• Release Notes
  • Version 55.2.0
  • Version 55.1.0
  • Version 55.0.0