Re: Oracle to postgres migration

From: Avinash Vallarapu <avinash(dot)vallarapu(at)gmail(dot)com>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: Julien Rouhaud <rjuju123(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Oracle to postgres migration
Date: 2025-01-27 09:33:28
Message-ID: CAN0TujcpFEfciZUZ5_mWRd-oeeFxUz0Qkrz3aQhyNQu+C+H=jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On Mon, Jan 27, 2025 at 3:01 PM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:

> 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
>
You can also use the Ora2Pg AI Chatbot, so that you can get responses if
you are stuck while using Ora2Pg.

https://ora2pgsupport.hexacluster.ai/

>
> 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.
>>
>

--
Regards,
Avinash Vallarapu
CEO
HexaCluster (www.hexacluster.ai)
Try our new Database Migration Service: www.hexarocket.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message manish yadav 2025-01-27 09:43:30 Re: Oracle to postgres migration
Previous Message Rajesh Kumar 2025-01-27 09:30:44 Re: Oracle to postgres migration