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

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