Re: Oracle to postgres migration

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Oracle to postgres migration
Date: 2025-01-27 09:30:44
Message-ID: CAJk5Atbqq8j8zjRUMcwCpSmqMPZP143tf0tK-bPDVJ5Uwr8V3A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Size is 300gb, have lob objects. I prefer ora2pg. Does EDB MTK costs?

Mostly I need to know what are all the things I need to ask oracle people
to start withj

On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, <rjuju123(at)gmail(dot)com> wrote:

> Hi,
>
> On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar wrote:
> > Hi team,
> >
> > I am trying to migrate from oracle to postgres.
> >
> > I have been asked to provide an estimation for effort days. Anybody has
> any
> > document related to estimation? And steps.
> >
> > Where do I start with? Anybody has any documentation related to ora2pg
> > migration ?
>
> ora2pg is probably the best tool for your task. And yes it does provide
> estimates for the migration efforts, see
> https://ora2pg.darold.net/documentation.html#Migration-cost-assessment.
>
> In general the ora2pg documentation is really good, you should find the
> answer
> to all your questions there.
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Avinash Vallarapu 2025-01-27 09:33:28 Re: Oracle to postgres migration
Previous Message Julien Rouhaud 2025-01-27 09:22:31 Re: Oracle to postgres migration