Database Migration Assessment

The DMA module offers a preliminary estimate of the effort needed to migrate on Oracle database to PostgreSQL.

Upon receiving an SQL Developer export in an .zip archive format, the module parses and analyzes the contained SQL files. This entire process is executed within the browser, without relying on any external resources.

SQL Developer Export Instructions

  1. Launch SQL Developer and ensure your database has been introspected
  2. Navigate to Tools > Database Export to open the Export Wizard
  3. In the Source/Destination tab:
    • Choose your database connection
    • Disable the Export Data option
    • Select Save As Separate Directory and enable Compressed
    • Specify the desired output path in the File field (e.g., HR.zip)
    • Click Next
  4. In the Types to Export tab, click Next
  5. In the Specify Objects tab:
    • Click More…
    • Choose the desired Schema (e.g., HR)
    • Click Lookup and wait for all database objects to load
    • Click » to export all database objects
    • Click Next
  6. In the Export Summary tab, click Finish