Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle -> Pg migration - Mailing list pgsql-novice

From Muhammad Ikram
Subject Re: Oracle -> Pg migration
Date
Msg-id CAJQ7xG6SqBENUOaGxw+EkRJ25QTeZ547Cjf4pQRXCPFv_YsviQ@mail.gmail.com
Whole thread Raw
In response to Oracle -> Pg migration  (Laszlo Forro <getforum@gmail.com>)
List pgsql-novice
Tree view
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.

pgsql-novice by date:

Previous
From: Laszlo Forro
Date:
Subject: Oracle -> Pg migration
Next
From: Onni Hakala
Date:
Subject: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server