Re: Oracle to Postgres

Thank you, Ron and Muhammad!

On Tue, Jul 23, 2024 at 4:21 AM Muhammad Ikram <mmikram(at)gmail(dot)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(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
>
>

--

*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>