cancel
Showing results for 
Search instead for 
Did you mean: 

EDB Postgres Migration Portal Quick Start Guide

Community Manager

EDB Postgres Migration Portal Quick Start Guide

  1. Download EDB’s DDL Extractor for Oracle Database. This extractor is frequently updated, please download the most recent version from the EDB Migration Portal.
  2. Connect to your Oracle database using SQL*Plus. Use a database account with SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY privileges.
  3. Run the DDL Extractor with the command SQL>@edb_ddl_extractor.sql.
  4. The DDL Extractor will ask for the username, password and the path where the extraction file will be created.

    Example for Linux Machines:
    	Enter SCHEMA_NAME to extract the DDLs : HR
    	Enter  PATH  to store DDL file : /home/oracle/extracted_ddls/
    
    Example for Windows Machines:
    	Enter SCHEMA_NAME to extract the DDLs : HR
    	Enter PATH to store DDL file : C:/Extracted_DDL/
  5. Go to https://migration.enterprisedb.com
  6. Log in with your EDB website credentials.
  7. Create a new project, open this project and click on ‘Assess.
  8. Enter the schema name and upload the file generated by the EDB DDL Extractor for Oracle Database. Do not modify this text file.
  9. Click on ‘Assess’. The analysis tool will review every construct, execute repair actions to improve compatibility with EDB Advanced Server, and flag any remaining errors that require manual intervention.
  10. Inspect the DDL objects, e.g., TABLES, that do not show a 100% success ratio.
  11. Click on individual objects that are not compatible.
  12. Use the editor to make necessary changes and click on ‘Assess’ to rerun the analysis.
  13. Consult the Knowledge Base (will open in a new tab) to identify possible workarounds.
  14. When you have finished working with the DDL, you can download the modified, EDB compatible DDL, as a text file and apply it to an existing EDB Advanced Server instance. The EDB Advanced Server instance has to be installed in Redwood Mode to enable native compatibility with key Oracle capabilities.