Migration Portal quick start v4

To migrate Oracle schemas using Migration Portal:

  1. Generate a .sql file with metadata information of your schemas. For more information, see Performing a schema extraction.

  2. Log in to Migration Portal with your EDB credentials.

  3. Create a new project.

  4. Upload the .sql file with your schema metadata.


    Uploading large DDL files might freeze or crash the browser (depending on the browser and the system resources in use). In this scenario, try running Migration Portal in a different browser or extracting fewer schemas and uploading that file into Migration Portal.

  5. Select Create & assess. Migration Portal reviews every construct, executes repair actions to improve compatibility with EDB Postgres Advanced Server, and flags any remaining errors that require manual intervention.

  6. Verify the DDL objects, for example, TABLES that don't show a 100% success ratio.

  7. Select the objects that aren't compatible with EDB Postgres Advanced Server.

  8. To look up and understand possible workarounds for the objects that aren't compatible in EDB Postgres Advanced Server, refer to the Knowledge Base or interact with AI Copilot.


    Ensure you test all suggested solutions to confirm the converted schemas behave as expected.

  9. Make the required changes and select Reassess to rerun the analysis.

  10. After resolving errors in your schemas, you can download the modified EDB compatible DDL file and use any client application such as pgAdmin or PSQL client and migrate the schema to EDB Postgres Advanced Server. You can also migrate to EDB Postgres Advanced Server on the cloud. For more information, see Schema migration.