From: Eric Raskin <eraskin@paslists.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: postgresql to Oracle database migration
Date: Thu, 9 Mar 2023 08:08:35 -0500
Message-ID: <CAF9L-R7tqTcw-w3Rp5T0kyMoSHb1_t542ts2OJJSaNSzuauSSQ@mail.gmail.com> (raw)
In-Reply-To: <dca4d91d-7f1c-f5f0-9f3f-24b5eaeae0fa@jakobs.com>
References: <CAGNT6Q4tZzaQbHooi9by=AyiX8-B0MoB+uJNH5zjJ0zB1nxYDA@mail.gmail.com>
<dca4d91d-7f1c-f5f0-9f3f-24b5eaeae0fa@jakobs.com>
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
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: eraskin@paslists.com, pgsql-admin@lists.postgresql.org
Subject: Re: postgresql to Oracle database migration
In-Reply-To: <CAF9L-R7tqTcw-w3Rp5T0kyMoSHb1_t542ts2OJJSaNSzuauSSQ@mail.gmail.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