MIME-Version: 1.0
References: 
 <CAJk5AtavL_Q9AbcBw3J3oDmY+ggUC+Mgz-9RqOv0vHH1O9FQbA@mail.gmail.com>
 <Z5dQV9IVZcLjKN3b@jrouhaud>
In-Reply-To: <Z5dQV9IVZcLjKN3b@jrouhaud>
From: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Date: Mon, 27 Jan 2025 15:00:44 +0530
Message-ID: 
 <CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A@mail.gmail.com>
Subject: Re: Oracle to postgres migration
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dbec7b062cacbbbd"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A%40mail.gmail.com>
Precedence: bulk

--000000000000dbec7b062cacbbbd
Content-Type: text/plain; charset="UTF-8"

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

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

<p dir=3D"ltr">Size is 300gb, have lob objects. I prefer ora2pg. Does EDB M=
TK 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 gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, &lt;<a href=3D"m=
ailto:rjuju123@gmail.com">rjuju123@gmail.com</a>&gt; wrote:<br></div><block=
quote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc=
 solid;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>

--000000000000dbec7b062cacbbbd--