OraDump to PostgreSQL Features

• All versions of Oracle dump files are supported (both EXP and EXPDP).
• All versions of Linux/Unix and Windows PostgreSQL are supported.
• Encrypted dump files are supported.
• Converts parallel export Oracle dump files.
• SSL connection for PostgreSQL is supported.
• Option to merge Oracle data into an existing PostgreSQL database.
• Option to synchronize PostgreSQL database with Oracle data.
• Option to convert individual tables.
• Option to export into PostgreSQL script file.
• Converts indexes with all necessary attributes.
• Stores conversion settings into profile.
• Command line support.
• The product can be customized according to customer requirements.
• Unlimited 24/7 support service.
• 1-year subscription for updates.

OraDump to PostgreSQL Limitations

• Does not support compressed dump files.
• Does not convert views, stored procedures and triggers.
• Does not convert columns having user-defined types.

Synchronization
OraDump-to-PostgreSQL implements synchronization as combination of insert Oracle records that are missing in PostgreSQL table and update existing PostgreSQL records with Oracle data. For synchronization purpose source and destination tables must have identical structures and primary key or unique index defined.

PostgreSQL script file
Oracle to PostgreSQL converter allows users to migrate Oracle database into PostgreSQL format even when there is no direct connection to the destination server. Following this approach, the program exports Oracle data into a local PostgreSQL script file instead of transferring it to database server directly. The output file contains SQL statements defining all tables and inserting the data. This article explains how to import script files into PostgreSQL database.