MIME-Version: 1.0
References: 
 <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
 <Z5dQV9IVZcLjKN3b@jrouhaud>
 <CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A@mail.gmail.com>
In-Reply-To: 
 <CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 27 Jan 2025 05:09:42 -0500
Message-ID: 
 <CANzqJaBAGHKG_Vc38BbLau_UGcvGomm-rFahpAJ814vV3V4fog@mail.gmail.com>
Subject: Re: Oracle to postgres migration
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000015e66d062cad477f"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaBAGHKG_Vc38BbLau_UGcvGomm-rFahpAJ814vV3V4fog%40mail.gmail.com>
Precedence: bulk

--00000000000015e66d062cad477f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

I migrated a 12TB Oracle db that was mostly LOB objects into an 8TB PG
database.  LOBs loaded into bytea columns.
One thing which I did not do, but should have, was have ora2pg convert
NUMBER(38,0) values to BIGINT.

We just used ora2pg to convert data; the app developer rewrote all of the
stored procedures, functions, triggers, etc.

On Mon, Jan 27, 2025 at 4:31=E2=80=AFAM Rajesh Kumar <rajeshkumar.dba09@gma=
il.com>
wrote:

> Size is 300gb, have lob objects. I prefer ora2pg. Does EDB MTK costs?
>
> Mostly I need to know what are all the things I need to ask oracle people
> to start withj
>
> On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, <rjuju123@gmail.com> wrote:
>
>> Hi,
>>
>> On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar wrote:
>> > Hi team,
>> >
>> > I am trying to migrate from oracle to postgres.
>> >
>> > I have been asked to provide an estimation for effort days. Anybody ha=
s
>> any
>> > document related to estimation? And steps.
>> >
>> > Where do I start with? Anybody has any documentation related to ora2pg
>> > migration ?
>>
>> ora2pg is probably the best tool for your task.  And yes it does provide
>> estimates for the migration efforts, see
>> https://ora2pg.darold.net/documentation.html#Migration-cost-assessment.
>>
>> In general the ora2pg documentation is really good, you should find the
>> answer
>> to all your questions there.
>>
>

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div>I migrated a 12TB Oracle db that was mostly LOB objec=
ts into an 8TB PG database.=C2=A0 LOBs loaded into bytea columns.</div><div=
>One thing which I did not do, but should have, was have ora2pg convert NUM=
BER(38,0) values to BIGINT.</div><div><br></div><div>We just used ora2pg to=
 convert data; the app developer rewrote all of the stored procedures, func=
tions, triggers, etc.</div><div dir=3D"ltr"><br></div><div class=3D"gmail_q=
uote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, J=
an 27, 2025 at 4:31=E2=80=AFAM Rajesh Kumar &lt;<a href=3D"mailto:rajeshkum=
ar.dba09@gmail.com">rajeshkumar.dba09@gmail.com</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><p dir=3D"ltr">Size is 300gb=
, have lob objects. I prefer ora2pg. Does EDB MTK costs?</p>
<p dir=3D"ltr">Mostly I need to know what are all the things I need to ask =
oracle people to start withj</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon=
, 27 Jan 2025, 14:52 Julien Rouhaud, &lt;<a href=3D"mailto:rjuju123@gmail.c=
om" target=3D"_blank">rjuju123@gmail.com</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar wrote:<br>
&gt; Hi team,<br>
&gt;<br>
&gt; I am trying to migrate from oracle to postgres.<br>
&gt;<br>
&gt; I have been asked to provide an estimation for effort days. Anybody ha=
s any<br>
&gt; document related to estimation? And steps.<br>
&gt;<br>
&gt; Where do I start with? Anybody has any documentation related to ora2pg=
<br>
&gt; migration ?<br>
<br>
ora2pg is probably the best tool for your task.=C2=A0 And yes it does provi=
de<br>
estimates for the migration efforts, see<br>
<a href=3D"https://ora2pg.darold.net/documentation.html#Migration-cost-asse=
ssment" rel=3D"noreferrer noreferrer" target=3D"_blank">https://ora2pg.daro=
ld.net/documentation.html#Migration-cost-assessment</a>.<br>
<br>
In general the ora2pg documentation is really good, you should find the ans=
wer<br>
to all your questions there.<br>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div></div>

--00000000000015e66d062cad477f--