Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgresql to Oracle database migration

postgresql to Oracle database migration

From
Renjith Gk
Date:
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

Re: postgresql to Oracle database migration

From
Holger Jakobs
Date:
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
Attachment

Re: postgresql to Oracle database migration

From
Eric Raskin
Date:
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


Re: postgresql to Oracle database migration

From
Sumit Sengupta
Date:
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 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

Re: postgresql to Oracle database migration

From
Piergiorgio Valli
Date:
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 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