From: Sam Stearns <sam.stearns@dat.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Oracle to Postgres
Date: Tue, 23 Jul 2024 13:53:39 +0930
Message-ID: <E711BC2C-93DF-44FF-9FB1-A9352A30BE26@dat.com> (raw)
In-Reply-To: <CANzqJaABFWcdphGXju8N5SHJs2AH10uA_ocpkBXg9YJ5ZZHxHg@mail.gmail.com>
References: <CANzqJaABFWcdphGXju8N5SHJs2AH10uA_ocpkBXg9YJ5ZZHxHg@mail.gmail.com>
--Apple-Mail-FD41D565-00BA-4265-B30E-3B39AE69D320
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 Ron,<div><br></div><div>Any suggesti=
on for plsql?</div><div><br></div><div><div dir=3D"ltr">Sent from my iPhone<=
/div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Jul 22, 2024, at 10:1=
6=E2=80=AFPM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:<br><br></bl=
ockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D=
"ltr"><div><br></div><div>ora2pg certainly migrated all the data objects tha=
t we cared about (including CLOB and XML types). That was 2-3 years ag=
o.</div><div><br></div><div>Didn't ask it to migrate plsql.</div><div><br></=
div><div dir=3D"ltr">On Mon, Jul 22, 2024 at 8:38=E2=80=AFAM Peter Garza <=
;<a href=3D"mailto:peter.garza@dat.com">peter.garza@dat.com</a>> wrote:<b=
r></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><span style=3D"box-sizing:inherit;color:rgb(29,28,29=
);word-break:break-word;font-family:Slack-Lato,Slack-Fractions,appleLogo,san=
s-serif;font-size:15px;font-variant-ligatures:common-ligatures;background-co=
lor:rgb(248,248,248)"><span role=3D"presentation" style=3D"box-sizing:inheri=
t;width:fit-content;height:fit-content;display:inline-flex"><button type=3D"=
button" style=3D"box-sizing:inherit;background-image:initial;background-posi=
tion:0px 0px;background-size:initial;background-repeat:initial;background-or=
igin:initial;background-clip:initial;border-width:0px;border-style:initial;b=
order-color:initial;padding:0px;font:inherit;overflow:initial;text-align:ini=
tial;vertical-align:baseline;margin:0px"><br>Peter Garza</button></span><spa=
n id=3D"m_3383958532497247761gmail-secondary-C07ABNGBS4D-1720746398.149879-s=
ender" aria-hidden=3D"true" style=3D"box-sizing:inherit;border:0px;width:1px=
;height:1px;padding:0px;overflow:hidden">Peter Garza</span></span><span styl=
e=3D"color:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,sa=
ns-serif;font-size:15px;font-variant-ligatures:common-ligatures;background-c=
olor:rgb(248,248,248)"> </span><a aria-label=3D"Yesterday at 6:06=
:38 PM" href=3D"https://dat-solutions.slack.com/archives/C07ABNGBS4D/p172074=
6398149879?thread_ts=3D1720745054.429439&cid=3DC07ABNGBS4D" style=3D"box=
-sizing:inherit;text-decoration-line:none;font-size:12px;font-family:Slack-L=
ato,Slack-Fractions,appleLogo,sans-serif;font-variant-ligatures:common-ligat=
ures;background-color:rgb(248,248,248)" target=3D"_blank"><span style=3D"box=
-sizing:inherit">10 hours ago</span></a><br style=3D"box-sizing:inherit;colo=
r:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,sans-serif;=
font-size:15px;font-variant-ligatures:common-ligatures;background-color:rgb(=
248,248,248)"><div style=3D"box-sizing:inherit;max-width:none;margin-bottom:=
4px;color:rgb(29,28,29);font-family:Slack-Lato,Slack-Fractions,appleLogo,san=
s-serif;font-size:15px;font-variant-ligatures:common-ligatures;background-co=
lor:rgb(248,248,248)"><div style=3D"box-sizing:inherit;max-width:none"><div s=
tyle=3D"box-sizing:inherit;width:664px"><div style=3D"box-sizing:inherit;dis=
play:flex"><div dir=3D"auto" style=3D"box-sizing:inherit;width:664px;overflo=
w-y:hidden;line-height:1.46668"><div style=3D"box-sizing:inherit">Here is a g=
ood paper - Please note that EBT Migration Portal goes with the Postgr=
es Advanced Server. <br>Thank You<br><br style=3D"box-sizing:inherit"><=
a href=3D"https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresq=
l-migration-guide-tutorial-move-convert-database-oracle-alternative" rel=3D"=
noopener noreferrer" style=3D"box-sizing:inherit;text-decoration-line:none" t=
arget=3D"_blank">https://www.enterprisedb.com/blog/the-complete-oracle-to-po=
stgresql-migration-guide-tutorial-move-convert-database-oracle-alternative</=
a><br><br><div><image.png></div><br></div></div></div></div></div></di=
v></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Thu, Jul 11, 2024 at 9:18=E2=80=AFPM Kashif Zeeshan <<a href=3D"mailt=
o:kashi.zeeshan@gmail.com" target=3D"_blank">kashi.zeeshan@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=
"ltr">Hi Sam<div><br></div><div>There are alot of open source and proprietar=
y solutions available, but you should choose between them carefully&nbs=
p;as cost is not the only factor.\</div><div>EDB's MTK (Migration Toolkit) a=
nd Migration Portal are solid products for this purpose.</div><div><br></div=
><div>Regards</div><div>Kashif Zeeshan</div></div><br><div class=3D"gmail_qu=
ote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 12, 2024 at 5:02=E2=80=
=AFAM Sam Stearns <<a href=3D"mailto:sam.stearns@dat.com" target=3D"_blan=
k">sam.stearns@dat.com</a>> wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin: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 pro=
ject to migrate our Oracle databases that are hosted on an Oracle Database A=
ppliance to Postgres 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 resour=
ce sizing on the Appliance that will give resource sizing recommendations fo=
r the VM?</li><li>Is there a schema conversion tool or similar out there tha=
t we can use to convert Oracle =3D=3D> Postgres?</li></ol><div>Thanks,</d=
iv><div><br></div><div>Sam</div><div><br></div><span class=3D"gmail_signatur=
e_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D=
"ltr"><p style=3D"color:rgb(0,0,0);font-family:Gotham,"Helvetica Neue&q=
uot;,Helvetica,Arial,sans-serif;font-size:0.8rem;line-height:1.2rem"><strong=
style=3D"font-size:0.9rem;color:rgb(51,51,51)">Samuel Stearns</strong><br><=
span style=3D"color:rgb(102,102,102)">Lead Database Administrator<br><strong=
>c:</strong> 971 762 6879 <span style=3D"color:rgb(147,149,152)">|=
</span> <strong>o:</strong> 503 672 5115 <span style=3D"color=
:rgb(147,149,152)">|</span> DAT.com</span></p><div style=3D"color:rgb(0=
,0,0);font-family:"Times New Roman";font-size:medium"><a href=3D"h=
ttps://www.dat.com/?utm_medium=3Demail&utm_source=3DDAT_email_signature_=
link" target=3D"_blank"><img src=3D"https://www.dat.com/wp-content/uploads/m=
edia/images/global/emails/signature2/dat_126.png" alt=3D"DAT" width=3D"126" h=
eight=3D"54" data-unique-identifier=3D""></a></div></div></div></div></div>
</blockquote></div>
</blockquote></div>
</blockquote></div></div>
</div></blockquote></div></body></html>=
--Apple-Mail-FD41D565-00BA-4265-B30E-3B39AE69D320--
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, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Oracle to Postgres
In-Reply-To: <E711BC2C-93DF-44FF-9FB1-A9352A30BE26@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