Re: Oracle to postgres migration

[Raphael Salguero Aragón <raphael.salguero@xxxxxxxxxxxxxxxx>]

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.zeeshan@xxxxxxxxx> 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.dba09@xxxxxxxxx> 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