Re: postgresql to Oracle database migration

Поиск

Список

Период

Сортировка

От	Eric Raskin
Тема	Re: postgresql to Oracle database migration
Дата	9 марта 2023 г. 16:08:35
Msg-id	CAF9L-R7tqTcw-w3Rp5T0kyMoSHb1_t542ts2OJJSaNSzuauSSQ@mail.gmail.com обсуждение исходный текст
Ответ на	Re: postgresql to Oracle database migration (Holger Jakobs <holger@jakobs.com>)
Список	pgsql-admin

Дерево обсуждения

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