Re: Oracle to Postgres

Hi Sam,

EnterpriseDB Migration Toolkit though won't analyze but can do migration
of both objects and data. Migration Portal from EDB is good for assessing
and migrating Schema. It provides you opportunity to reassess failed
objects after manual repair as well.
You may use the Migration portal for schema objects and then MTK for data
migration.

ora2pg is a free tool and good for both but have not used much.

About Analysis for resources, we have noticed that after migration db takes
much less space as compared to Oracle.

Regards,
Muhammad Ikram

On Fri, Jul 12, 2024 at 5:02 AM 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?
> 2. Is there a schema conversion tool or similar out there that we can
> use to convert Oracle ==> Postgres?
>
> Thanks,
>
> Sam
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
>

--
Muhammad Ikram