MIME-Version: 1.0
References: 
 <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
 <Z5dQV9IVZcLjKN3b@jrouhaud>
 <CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A@mail.gmail.com>
 <CANzqJaBAGHKG_Vc38BbLau_UGcvGomm-rFahpAJ814vV3V4fog@mail.gmail.com>
In-Reply-To: 
 <CANzqJaBAGHKG_Vc38BbLau_UGcvGomm-rFahpAJ814vV3V4fog@mail.gmail.com>
From: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Date: Mon, 27 Jan 2025 15:41:59 +0530
Message-ID: 
 <CAJk5Atb417VyDWX=Ag=RiZxTS2WGjRoWKfzn+iHpHJD7UD=20g@mail.gmail.com>
Subject: Re: Oracle to postgres migration
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000052282a062cad4f95"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5Atb417VyDWX%3DAg%3DRiZxTS2WGjRoWKfzn%2BiHpHJD7UD%3D20g%40mail.gmail.com>
Precedence: bulk

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

Thank you all. As mush as more info is always appreciated by dearest admins

On Mon, 27 Jan 2025, 15:40 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:

> 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@g=
mail.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 peopl=
e
>> 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
>>> has any
>>> > document related to estimation? And steps.
>>> >
>>> > Where do I start with? Anybody has any documentation related to ora2p=
g
>>> > migration ?
>>>
>>> ora2pg is probably the best tool for your task.  And yes it does provid=
e
>>> 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.
>>>
>>
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<p dir=3D"ltr">Thank you all. As mush as more info is always appreciated by=
 dearest admins </p>
<br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Mon, 27 Jan 2025, 15:40 Ron Johnson, &lt;<a href=3D"mail=
to:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>I migrated a 12TB Ora=
cle db that was mostly LOB objects into an 8TB PG database.=C2=A0 LOBs load=
ed into bytea columns.</div><div>One thing which I did not do, but should h=
ave, was have ora2pg convert NUMBER(38,0) values to BIGINT.</div><div><br><=
/div><div>We just used ora2pg to convert data; the app developer rewrote al=
l of the stored procedures, functions, triggers, etc.</div><div dir=3D"ltr"=
><br></div><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Mon, Jan 27, 2025 at 4:31=E2=80=AFAM Rajesh Kumar &lt;<a href=3D"mailto=
:rajeshkumar.dba09@gmail.com" target=3D"_blank" rel=3D"noreferrer">rajeshku=
mar.dba09@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left: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" rel=3D"noreferrer">rjuju123@gmail.com</a>&gt; wrote:<=
br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid 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 noreferrer" target=3D"_blank">https://=
ora2pg.darold.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>
</blockquote></div>

--00000000000052282a062cad4f95--