Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Oracle to postgres migration
Date
Msg-id CANzqJaBAGHKG_Vc38BbLau_UGcvGomm-rFahpAJ814vV3V4fog@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to postgres migration  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Oracle to postgres migration
List pgsql-admin
Tree view
I migrated a 12TB Oracle db that was mostly LOB objects into an 8TB PG database.  LOBs loaded into bytea columns.
One thing which I did not do, but should have, was have ora2pg convert NUMBER(38,0) values to BIGINT.

We just used ora2pg to convert data; the app developer rewrote all of the stored procedures, functions, triggers, etc.

On Mon, Jan 27, 2025 at 4:31 AM Rajesh Kumar <rajeshkumar.dba09@gmail.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

On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, <rjuju123@gmail.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.


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: manish yadav
Date:
Subject: Re: Oracle to postgres migration
Next
From: Rajesh Kumar
Date:
Subject: Re: Oracle to postgres migration