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@gmail.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@gmail.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