Thread: Oracle -> Pg migration
Hi dear community,
We are to dig into the option of migrating an Oracle db to Pg and found the Ora2Pg. However, that seem to do data migration, requires running Oracle db. We would like to dump the Oracle object declarations (create statements in SQL files) and move it to Pg first, no data migrated.
Can you guide us if there is any tool that can support this approach?
Thank you very much!
LF.
Hi
Could you check the INPUT_FILE parameter in ora2pg config file ? I think you can provide a SQL file instead of live connection.
or try
ora2pg -i /path/to/your/oracle_export.sql -o output.sql
Regards,
Muhammad Ikram
On Wed, Sep 11, 2024 at 2:27 PM Laszlo Forro <getforum@gmail.com> wrote:
Hi dear community,We are to dig into the option of migrating an Oracle db to Pg and found the Ora2Pg. However, that seem to do data migration, requires running Oracle db. We would like to dump the Oracle object declarations (create statements in SQL files) and move it to Pg first, no data migrated.Can you guide us if there is any tool that can support this approach?Thank you very much!LF.