Re: Oracle to Postgres

[Sam Stearns <sam.stearns@xxxxxxx>]

Thank you, Ron and Muhammad!

On Tue, Jul 23, 2024 at 4:21 AM Muhammad Ikram <mmikram@xxxxxxxxx> wrote:

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.stearns@xxxxxxx> 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

--

Muhammad Ikram

--

Samuel Stearns
Lead Database Administrator
c: 971 762 6879 | o: 503 672 5115 | DAT.com