Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to Postgres - Mailing list pgsql-admin

From Sam Stearns
Subject Re: Oracle to Postgres
Date
Msg-id CAN6TVj=3OijTDQ_M_Bv1GF_egwPf_DLSfNJS-FVtzThxkP=BWQ@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to Postgres  (Muhammad Ikram <mmikram@gmail.com>)
List pgsql-admin
Tree view
Thank you, Ron and Muhammad!

On Tue, Jul 23, 2024 at 4:21 AM Muhammad Ikram <mmikram@gmail.com> 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@dat.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

DAT


--
Muhammad Ikram



--

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

DAT

pgsql-admin by date:

Previous
From: Muhammad Ikram
Date:
Subject: Re: Oracle to Postgres
Next
From: Ron Johnson
Date:
Subject: Re: Oracle to Postgres