Re: Oracle to postgres migration

Поиск
Список
Период
Сортировка
От Timo Myyrä
Тема Re: Oracle to postgres migration
Дата
Msg-id 1514291558.2940368.1216079744.27D31833@webmail.messagingengine.com
обсуждение исходный текст
Ответ на Re: Oracle to postgres migration  (Vasilis Ventirozos <v.ventirozos@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote:
I'd start with this first : https://ora2pg.darold.net

On 26 Dec 2017, at 02:30, Azimuddin Mohammed <azimeiu@gmail.com> wrote:

Hello,
Can anyone guide me through the steps for migration from oracle to postgres with config changes required, keeping in mind that neither I am a oracle DBA not postgres admin

--

Regards,
Azim


Virus-free. www.avast.com

I second the ora2pg tool. Currently working on oracle to postgresql migration with it and ora2pg helps a lot.
But you can't get ready recipe for migration. There's ton of stuff to consider from trivial rewriting NVL queries to use COALESCE to more bigger stuff like lack of synonyms in postgresql. All depends on your current Oracle database.

Timo

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Getting rid of "tuple concurrently updated" elog()s withconcurrent DDLs (at least ALTER TABLE)
Следующее
От: Edson Carlos Ericksson Richter
Дата:
Сообщение: Does PostgreSQL check database integrity at startup?