Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to postgres migration - Mailing list pgsql-admin

From Raphael Salguero Aragón
Subject Re: Oracle to postgres migration
Date
Msg-id CAA2=wKaQeJxmwnhf5NWgKFCD5EM8D92wPSzDFfVnp0jgnaddVA@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to postgres migration  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
List pgsql-admin
Tree view
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@gmail.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.



On Mon, Jan 27, 2025 at 2:12 PM Rajesh Kumar <rajeshkumar.dba09@gmail.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 

pgsql-admin by date:

Previous
From: Kashif Zeeshan
Date:
Subject: Re: Oracle to postgres migration
Next
From: Julien Rouhaud
Date:
Subject: Re: Oracle to postgres migration