public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Ikram <[email protected]>
To: Laszlo Forro <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Oracle -> Pg migration
Date: Wed, 11 Sep 2024 17:05:43 +0500
Message-ID: <CAJQ7xG6SqBENUOaGxw+EkRJ25QTeZ547Cjf4pQRXCPFv_YsviQ@mail.gmail.com> (raw)
In-Reply-To: <CAHsHJAjfwF1gso5j=oa62GrZB2HTRDD2yc3D22YKi_VwrA3vtg@mail.gmail.com>
References: <CAHsHJAjfwF1gso5j=oa62GrZB2HTRDD2yc3D22YKi_VwrA3vtg@mail.gmail.com>

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.
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Oracle -> Pg migration
  In-Reply-To: <CAJQ7xG6SqBENUOaGxw+EkRJ25QTeZ547Cjf4pQRXCPFv_YsviQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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