MIME-Version: 1.0
From: Laszlo Forro <getforum@gmail.com>
Date: Wed, 11 Sep 2024 11:19:06 +0200
Message-ID: 
 <CAHsHJAjfwF1gso5j=oa62GrZB2HTRDD2yc3D22YKi_VwrA3vtg@mail.gmail.com>
Subject: Oracle -> Pg migration
To: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000680ea40621d49701"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHsHJAjfwF1gso5j%3Doa62GrZB2HTRDD2yc3D22YKi_VwrA3vtg%40mail.gmail.com>
Precedence: bulk

--000000000000680ea40621d49701
Content-Type: text/plain; charset="UTF-8"

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.

--000000000000680ea40621d49701
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi dear community,</div><div>We are to dig into the o=
ption of migrating an Oracle db to Pg and found the Ora2Pg. However, that s=
eem to do data migration, requires running Oracle db. We would like to dump=
 the Oracle object declarations (create statements in SQL files) and move i=
t to Pg first, no data migrated.<br></div><div>Can you guide us if there is=
 any tool that can support this approach?</div><div>Thank you very much!</d=
iv><div>LF.<br></div></div>

--000000000000680ea40621d49701--