Re: Oracle to postgres migration

Hi Rajesh,

ora2pg is a good starting point to get an overview about the complexity.
But the effort for manual conversion also depends on your experiences and
skills. That’s something you can adjust with the cost factors using ora2pg.
Data migration is a different aspect. That depends on the db size, your
object types and the migration method.

I would suggest to get started with ora2pg first.

Best regards
Raphael

Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> schrieb am Mo. 27. Jan. 2025 um
10:15:

> Hi Rajesh
>
> You can use EDB's Migration ToolKit (MTK) and following is the link to the
> documentation.
>
> https://www.enterprisedb.com/docs/migration_toolkit/latest/
>
>
> On Mon, Jan 27, 2025 at 2:12 PM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> 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.
>>
>
> The time depends on the size of the data needed to migrate.
>
> Thanks
> Kashif Zeeshan
>
>
>>
>> Where do I start with? Anybody has any documentation related to ora2pg
>> migration ?
>>
>> A little help is appreciated
>>
>