Re: Oracle to Postgres

On Thu, Jul 11, 2024 at 8:02 PM Sam Stearns <sam(dot)stearns(at)dat(dot)com> wrote:

> Howdy,
>
> We have a project to migrate our Oracle databases that are hosted on an
> Oracle Database Appliance to Postgres hosted on a Linux VM. Questions:
>
>
> 1. Is there a tool out there that we can use to analyze resource
> sizing on the Appliance that will give resource sizing recommendations for
> the VM?
>
>
The appliance doesn't tell you how much space your database uses???

Anyway, we converted an 8TB on-prem Oracle 12 db (heavy on CLOBs) to RDS
Postgresql 12; the resulting db was about 6TB. I'm sure that vanilla PG
would be about the same size (or smaller now, since compression on
dupes-allowed b-tree indices is much better now than in PG 12).

>
> 1. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
>
As Keith said, Google is your friend.

That's how I found ora2pg, which we used in our conversion project (for the
data only; someone had to rewrite all the stored procedures).

If you use ora2pg, remember to tell it to convert all of the NUMERIC(38,0)
columns to BIGINT.

>