Re: Oracle to postgres migration

You may try EDB Migration portal (https://migration.enterprisedb.com/)  for migration assessment which is freely available.  EDB MTK to be used for data migration which is under subscription plan.

Thanks and Regards,

Manish Yadav

On Monday 27 January, 2025 at 03:04:00 PM IST, Avinash Vallarapu <avinash(dot)vallarapu(at)gmail(dot)com> wrote:

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