Thread: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
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
On 2/25/25 18:00, Mahendra Singh 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
You should hire a DBA
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,
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
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,ora2pg is also a useful tool for migrating data from Oracle to PostgreSQL.Admin-pgOn 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
I understand! you can try with the actual version you're working with and follow the same migration steps.
On Wed, Feb 26, 2025 at 10:52 AM Mahendra Singh <msmahendrasingh18@gmail.com> wrote:
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,ora2pg is also a useful tool for migrating data from Oracle to PostgreSQL.Admin-pgOn 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