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

Поиск
Список
Период
Сортировка
От Mahendra Singh
Тема Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
Дата
Msg-id CA+Thq8H3rB+J3N95T43ENuiC_qURZdo2CyKORB-k=xsHYRcgaw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL  (Gayu thulasi <gayuthulasi24@gmail.com>)
Ответы Re: Migrate data from Oracle to EPAS, EPAS to PostgreSQL
Список pgsql-admin
Дерево обсуждения
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-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






В списке pgsql-admin по дате отправления: