pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql to Oracle database migration
6+ messages / 6 participants
[nested] [flat]
* postgresql to Oracle database migration
@ 2023-03-09 09:46 Renjith Gk <renjithgk@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Renjith Gk @ 2023-03-09 09:46 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
Can anyone confirm any online tool or best practice to migrate postgresql
queries to Oracle, there are few syntax differences compared from
postgresql to Oracle
Best regards,
Renjith
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql to Oracle database migration
@ 2023-03-09 09:48 Holger Jakobs <holger@jakobs.com>
parent: Renjith Gk <renjithgk@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Holger Jakobs @ 2023-03-09 09:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Am 09.03.23 um 10:46 schrieb Renjith Gk:
> Hi,
>
> Can anyone confirm any online tool or best practice to migrate
> postgresql queries to Oracle, there are few syntax differences
> compared from postgresql to Oracle
>
> Best regards,
> Renjith
There is no easy solution because Postgres' SQL dialect is a lot richer
than Oracle's.
Most trivial queries will work immediately.
Kind regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../../dca4d91d-7f1c-f5f0-9f3f-24b5eaeae0fa@jakobs.com/2-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql to Oracle database migration
@ 2023-03-09 13:08 Eric Raskin <eraskin@paslists.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 6+ messages in thread
From: Eric Raskin @ 2023-03-09 13:08 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Look into ora2pg https://ora2pg.darold.net/. I used it successfully years
ago, and it has been enhanced since. We migrated from a local Oracle
database to Google Cloud SQL PostgreSQL. There are differences that you
will have to repair manually, but the ora2pg website documents many of
them. There is also orafce https://github.com/orafce/orafce which contains
things like Oracle compatible date routines. I chose to fix the code
rather than use it as I wanted to remove all Oracle dependencies as much as
possible, but it does work.
Good luck.
Eric
On Thu, Mar 9, 2023 at 4:48 AM Holger Jakobs <holger@jakobs.com> wrote:
>
> Am 09.03.23 um 10:46 schrieb Renjith Gk:
> > Hi,
> >
> > Can anyone confirm any online tool or best practice to migrate
> > postgresql queries to Oracle, there are few syntax differences
> > compared from postgresql to Oracle
> >
> > Best regards,
> > Renjith
>
> There is no easy solution because Postgres' SQL dialect is a lot richer
> than Oracle's.
>
> Most trivial queries will work immediately.
>
> Kind regards,
>
> Holger
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>
--
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Eric H. Raskin
914-765-0500 x120 or *315-338-4461
(direct)*
Professional Advertising Systems Inc.
fax: 914-765-0500 or *315-338-4461 (direct)*
3 Morgan Drive #310
eraskin@paslists.com
Mt Kisco, NY 10549
http://www.paslists.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql to Oracle database migration
@ 2023-03-09 13:09 Sumit Sengupta <ssengupta@hotmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sumit Sengupta @ 2023-03-09 13:09 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Also Oracle considers zero byte character space as Null although they recommend not to assume it will stay that way. Here is a short blog<https://www.linkedin.com/pulse/null-value-differences-rdbms-sumit-sengupta; comparing Oracle, Postges, MySQL and SQL Server around Nulls.
________________________________
From: Holger Jakobs
Sent: Thursday, March 9, 2023 4:48 AM
To: pgsql-admin@lists.postgresql.org
Subject: Re: postgresql to Oracle database migration
Am 09.03.23 um 10:46 schrieb Renjith Gk:
> Hi,
>
> Can anyone confirm any online tool or best practice to migrate
> postgresql queries to Oracle, there are few syntax differences
> compared from postgresql to Oracle
>
> Best regards,
> Renjith
There is no easy solution because Postgres' SQL dialect is a lot richer
than Oracle's.
Most trivial queries will work immediately.
Kind regards,
Holger
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql to Oracle database migration
@ 2023-03-09 17:49 Jwiencek3 <jwiencek3@comcast.net>
parent: Sumit Sengupta <ssengupta@hotmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Jwiencek3 @ 2023-03-09 17:49 UTC (permalink / raw)
To: Sumit Sengupta <ssengupta@hotmail.com>; +Cc: Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org
--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--
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: postgresql to Oracle database migration
@ 2023-03-09 19:41 Piergiorgio Valli <piervalli@gmail.com>
parent: Jwiencek3 <jwiencek3@comcast.net>
0 siblings, 0 replies; 6+ messages in thread
From: Piergiorgio Valli @ 2023-03-09 19:41 UTC (permalink / raw)
To: Jwiencek3 <jwiencek3@comcast.net>; +Cc: Sumit Sengupta <ssengupta@hotmail.com>; Holger Jakobs <holger@jakobs.com>; pgsql-admin@lists.postgresql.org
Hi All,
nice question, there are many company that can do a professional support if
you need.
Thanks
Pier
Il giorno gio 9 mar 2023 alle ore 18:49 Jwiencek3 <jwiencek3@comcast.net>
ha scritto:
> The curious side of me would like to know what made you decide to migrate
> from postgresql to oracle? Seems the trend now-a-days is the reverse. Do
> you have a really large budget you need to eat up?
>
> Sent from my iPad
>
> On Mar 9, 2023, at 7:09 AM, Sumit Sengupta <ssengupta@hotmail.com> wrote:
>
>
> Also Oracle considers zero byte character space as Null although they
> recommend not to assume it will stay that way. Here is a short blog
> <https://www.linkedin.com/pulse/null-value-differences-rdbms-sumit-sengupta;
> comparing Oracle, Postges, MySQL and SQL Server around Nulls.
>
>
> ------------------------------
> *From:* Holger Jakobs
> *Sent:* Thursday, March 9, 2023 4:48 AM
> *To:* pgsql-admin@lists.postgresql.org
> *Subject:* Re: postgresql to Oracle database migration
>
>
> Am 09.03.23 um 10:46 schrieb Renjith Gk:
> > Hi,
> >
> > Can anyone confirm any online tool or best practice to migrate
> > postgresql queries to Oracle, there are few syntax differences
> > compared from postgresql to Oracle
> >
> > Best regards,
> > Renjith
>
> There is no easy solution because Postgres' SQL dialect is a lot richer
> than Oracle's.
>
> Most trivial queries will work immediately.
>
> Kind regards,
>
> Holger
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-03-09 19:41 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-09 09:46 postgresql to Oracle database migration Renjith Gk <renjithgk@gmail.com>
2023-03-09 09:48 ` Holger Jakobs <holger@jakobs.com>
2023-03-09 13:08 ` Eric Raskin <eraskin@paslists.com>
2023-03-09 13:09 Re: postgresql to Oracle database migration Sumit Sengupta <ssengupta@hotmail.com>
2023-03-09 17:49 ` Jwiencek3 <jwiencek3@comcast.net>
2023-03-09 19:41 ` Piergiorgio Valli <piervalli@gmail.com>
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