From: Jwiencek3 <jwiencek3@comcast.net>
To: Sumit Sengupta <ssengupta@hotmail.com>
Cc: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: postgresql to Oracle database migration
Date: Thu, 9 Mar 2023 11:49:03 -0600
Message-ID: <3CF2F4B3-BAED-4118-B5C0-C52446151318@comcast.net> (raw)
In-Reply-To: <BL0PR06MB49784064310B755C42D677C1B3B59@BL0PR06MB4978.namprd06.prod.outlook.com>
References: <BL0PR06MB49784064310B755C42D677C1B3B59@BL0PR06MB4978.namprd06.prod.outlook.com>
--Apple-Mail-CEC33984-A111-4685-966A-075742E95D0A
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">The curious side of me would like to know w=
hat made you decide to migrate from postgresql to oracle? Seems the tr=
end now-a-days is the reverse. Do you have a really large budget you n=
eed to eat up?<br><br><div dir=3D"ltr">Sent from my iPad</div><div dir=3D"lt=
r"><br><blockquote type=3D"cite">On Mar 9, 2023, at 7:09 AM, Sumit Sengupta &=
lt;ssengupta@hotmail.com> wrote:<br><br></blockquote></div><blockquote ty=
pe=3D"cite"><div dir=3D"ltr">=EF=BB=BF
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-1=
">
<div style=3D"font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class=3D"elementT=
oProof">
Also Oracle considers zero byte character space as Null although they recomm=
end not to assume it will stay that way. Here is a short
<a href=3D"https://www.linkedin.com/pulse/null-value-differences-rdbms-sumit=
-sengupta" title=3D"https://www.linkedin.com/pulse/null-value-differences-rd=
bms-sumit-sengupta" id=3D"LPNoLPOWALinkPreview">
blog</a> comparing Oracle, Postges, MySQL and SQL Server around Nulls. =
</div>
<div class=3D"_Entity _EType_OWALinkPreview _EId_OWALinkPreview _EReadonly_1=
"></div>
<br>
<div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size:=
12pt; color: rgb(0, 0, 0);">
<br>
<hr tabindex=3D"-1" style=3D"display:inline-block; width:98%;">
<b>From:</b> Holger Jakobs<br>
<b>Sent:</b> Thursday, March 9, 2023 4:48 AM<br>
<b>To:</b> pgsql-admin@lists.postgresql.org<br>
<b>Subject:</b> Re: postgresql to Oracle database migration
<div><br>
</div>
</div>
<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:11pt;"=
>
<div class=3D"PlainText"><br>
Am 09.03.23 um 10:46 schrieb Renjith Gk:<br>
> Hi,<br>
><br>
> Can anyone confirm any online tool or best practice to migrate <br>
> postgresql queries to Oracle, there are few syntax differences <br>
> compared from postgresql to Oracle<br>
><br>
> Best regards,<br>
> Renjith<br>
<br>
There is no easy solution because Postgres' SQL dialect is a lot richer <br>=
than Oracle's.<br>
<br>
Most trivial queries will work immediately.<br>
<br>
Kind regards,<br>
<br>
Holger<br>
<br>
<br>
-- <br>
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012<br>
<br>
</div>
</span></font></div>
</div>
</div></blockquote></body></html>=
--Apple-Mail-CEC33984-A111-4685-966A-075742E95D0A--
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: jwiencek3@comcast.net, ssengupta@hotmail.com, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: postgresql to Oracle database migration
In-Reply-To: <3CF2F4B3-BAED-4118-B5C0-C52446151318@comcast.net>
* 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