public inbox for [email protected]  

help / color / mirror / Atom feed

Oracle -> Pg migration
2+ messages / 2 participants
[nested] [flat]

* Oracle -> Pg migration
@ 2024-09-11 09:19 Laszlo Forro <[email protected]>
  2024-09-11 12:05 ` Re: Oracle -> Pg migration Muhammad Ikram <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Laszlo Forro @ 2024-09-11 09:19 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Oracle -> Pg migration
  2024-09-11 09:19 Oracle -> Pg migration Laszlo Forro <[email protected]>
@ 2024-09-11 12:05 ` Muhammad Ikram <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Muhammad Ikram @ 2024-09-11 12:05 UTC (permalink / raw)
  To: Laszlo Forro <[email protected]>; +Cc: [email protected] <[email protected]>

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 <[email protected]> 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.
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-09-11 12:05 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-11 09:19 Oracle -> Pg migration Laszlo Forro <[email protected]>
2024-09-11 12:05 ` Muhammad Ikram <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox