Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL

I am sure EPAS 19 is not released yet. 17.4 is the latest that I am using.

Any more suggestions please.

On Wed, Feb 26, 2025 at 9:07 AM Gayu thulasi <gayuthulasi24(at)gmail(dot)com>
wrote:

> Hi Mahendra Singh,
>
> yes, it's possible to migrate data from EPAS 19, pg_dump from EPAS and
> restore it into PostgreSQL., but check the compatibility features.
>
> Reference for live compare,
>
>
> https://docs.devart.com/studio-for-postgresql/comparing-synchronizing-data/compare-sync-data-from-oracle.html
>
> https://docs-archive.enterprisedb.com/livecompare-index/
>
> ora2pg is also a useful tool for migrating data from Oracle to PostgreSQL.
>
> --
> Admin-pg
>
>
> On Tue, Feb 25, 2025 at 8:27 PM Mahendra Singh <
> msmahendrasingh18(at)gmail(dot)com> wrote:
>
>> Hello Gurus,
>>
>> Hope you all are doing well.
>>
>> I have already migrated data from Oracle 19c to EPAS 19 on Oracle Linux
>> using EDB Migration Toolkit. Now, I want to migrate the same data to
>> PostgreSQL community version.
>> Is it possible to do so? If yes then how?
>>
>> How shall I validate the data post migration? If any tool like
>> LiveCompare then please provide me the complete steps.
>>
>> Regards,
>> Mahendra Singh - DXB
>>
>>
>
>
>
>
>