Migrating a database

To migrate a database, you must complete the following steps:

1. Perform a Performing a schema extraction .

2. Perform a Performing a schema assessment .

3. Perform a Schema migration .

4. Perform a Data migration .

• Performing a schema extraction
  • Extracting schemas using the EDB DDL Extractor
    • Prerequisites
    • For SQL*Plus
    • For SQL Developer
    • Additional notes
  • Schemas and objects support
    • Unsupported schemas
    • Supported object types
    • Unsupported object types
  • Wrapped objects
  • About file encoding
    • Extracting schemas using data pump utility
• Performing a schema assessment
  • Perform a schema assessment
  • Generate an assessment report
• Schema migration
  • Migrating to an existing on-premises EDB Postgres Advanced Server host
    • Migrate schemas on Windows
    • Migrate schemas on Linux
  • Migrating to a new on-premises EDB Postgres Advanced Server installation
    • Migrate schemas on Windows
    • Migrate schemas on Linux
  • Migrate to the cloud
• Data migration