From: Sam Stearns <sam.stearns@dat.com>
To: Muhammad Ikram <mmikram@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Oracle to Postgres
Date: Tue, 23 Jul 2024 13:56:14 +0930
Message-ID: <41F9BECC-15C9-4409-8DD3-36D1F06EF9A8@dat.com> (raw)
In-Reply-To: <CAGeimVpmEL8Zr1kNuRub7nMCkjZeuCtU656VKCCqX0Cu1aEX+Q@mail.gmail.com>
References: <CAGeimVpmEL8Zr1kNuRub7nMCkjZeuCtU656VKCCqX0Cu1aEX+Q@mail.gmail.com>
--Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Thanks, Muhammad!<div><br id=3D"lineBreakAt=
BeginningOfSignature"><div dir=3D"ltr">Sent from my iPhone</div><div dir=3D"=
ltr"><br><blockquote type=3D"cite">On Jul 23, 2024, at 12:55=E2=80=AFPM, Muh=
ammad Ikram <mmikram@gmail.com> wrote:<br><br></blockquote></div><bloc=
kquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr">Hi Ron,<div>=
<br></div><div>An explanation here about what I said above. EDB's Migration t=
oolkit is not a choice if you want to migrate code objects (Procedures, Pack=
ages, Functions, Triggers etc) to community PostgreSQL. Migration Portal aga=
in assesses and converts for EDB Postgres which is much Oracle compatible.</=
div><div>EDB Migration toolkit can be good for data objects and data transfe=
r to Community Postgres. If you want to migrate to EDB Postgres (EPAS) then t=
hese tEDB ools are best for migrating code and data objects including data.<=
/div><div><br></div><div>For Oracle to Community Postgres <b>Ora2PG</b> is g=
ood enough</div><div><br></div><div>Regards,</div><div>Muhammad Ikram</div><=
div>Bitnine.</div><div><br></div></div><br><div class=3D"gmail_quote"><div d=
ir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 12, 2024 at 7:21=E2=80=AFAM Muha=
mmad Ikram <<a href=3D"mailto:mmikram@gmail.com">mmikram@gmail.com</a>>=
; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D=
"auto">Hi,</div><div dir=3D"auto"><br></div><div dir=3D"auto">Three tools I k=
now which can help .</div><div dir=3D"auto"><br></div><div dir=3D"auto">Ora2=
pg : A free tool that helps in migration of schema and data both. Rich in op=
tions and best suits for target vanila PG. </div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">EDB=E2=80=99s Migration toolkit can migrate both sch=
ema and dara but for vanila PG code objects won=E2=80=99t migrate. </di=
v><div dir=3D"auto">Amazon SCT converters schema and Amazon has service to m=
igrate data. </div><div dir=3D"auto"><br></div><div dir=3D"auto">Regard=
s,</div><div dir=3D"auto"><br clear=3D"all"><div dir=3D"auto"><div dir=3D"lt=
r" class=3D"gmail_signature"><div dir=3D"ltr"><div dir=3D"auto">Muhammad Ikr=
am<br>Bitnine Global</div></div></div></div></div><div><br></div><div><br><d=
iv class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 12 Ju=
l 2024 at 06:23, Ron Johnson <<a href=3D"mailto:ronljohnsonjr@gmail.com" t=
arget=3D"_blank">ronljohnsonjr@gmail.com</a>> wrote:<br></div><blockquote=
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On T=
hu, Jul 11, 2024 at 8:02=E2=80=AFPM Sam Stearns <<a href=3D"mailto:sam.st=
earns@dat.com" target=3D"_blank">sam.stearns@dat.com</a>> wrote:<br></div=
><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div dir=3D"ltr">Howdy,<div><br></div><div>We have a project to migrate our=
Oracle databases that are hosted on an Oracle Database Appliance to Postgre=
s hosted on a Linux VM. Questions:</div><div><br></div><div><ol><li>Is=
there a tool out there that we can use to analyze resource sizing on the Ap=
pliance that will give resource sizing recommendations for the VM?</li></ol>=
</div></div></blockquote><div><br></div><div>The appliance doesn't tell you h=
ow much space your database uses???</div><div><br></div><div>Anyway, we conv=
erted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS Postgresql 12; the=
resulting db was about 6TB. I'm sure that vanilla PG would be about t=
he same size (or smaller now, since compression on dupes-allowed b-tree=
indices is much better now than in PG 12).</div><div> </div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div><ol><li>Is ther=
e a schema conversion tool or similar out there that we can use to convert O=
racle =3D=3D> Postgres?</li></ol></div></div></blockquote><div><br></div>=
<div>As Keith said, Google is your friend.</div><div><br></div><div>That's h=
ow I found ora2pg, which we used in our conversion project (for the data onl=
y; someone had to rewrite all the stored procedures).</div><div><br></div><d=
iv>If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0=
) columns to BIGINT.</div><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><=
div dir=3D"ltr"><div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"=
ltr"></div></div></div></div>
</blockquote></div></div>
</blockquote></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_sig=
nature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div=
dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>
</div></blockquote></div></body></html>=
--Apple-Mail-199B2ACA-6152-4A94-8047-EDD117E8A623--
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: pgsql-admin@postgresql.org
Cc: sam.stearns@dat.com, mmikram@gmail.com, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Oracle to Postgres
In-Reply-To: <41F9BECC-15C9-4409-8DD3-36D1F06EF9A8@dat.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox