Re: Oracle to PostgreSQL Migration

Поиск
Список
Период
Сортировка
От Umair Shahid
Тема Re: Oracle to PostgreSQL Migration
Дата
Msg-id CAM184AcqyTEHXJXdJYjzdfzDv9mLTWT+6F=j2eLt-uz_jca2eA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Oracle to PostgreSQL Migration  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
Ответы Re: Oracle to PostgreSQL Migration  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
Список pgsql-general
Дерево обсуждения
Could oracle_fdw help in your use case? You could consider setting up a job to pull data into PostgreSQL live and then cut over when you are ready. 

- Umair

On Tue, Mar 21, 2023 at 10:36 AM Inzamam Shafiq <inzamam.shafiq@hotmail.com> wrote:
Hi Thomas,

We have tried kafka, but in that we stuck in CDC part, update/delete was not working due to some NULL value issue. Do you have any helping material for Oracle to PostgreSQL data migration using debezium?

Regards,

Inzamam Shafiq
Sr. DBA
From: Thomas Kellerer <shammat@gmx.net>
Sent: Monday, March 20, 2023 7:21 PM
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Oracle to PostgreSQL Migration
 
Inzamam Shafiq schrieb am 20.03.2023 um 13:57:
> We have an Oracle DB which is around 1TB and we want to migrate to
> PostgreSQL that have a new table structure, so we want to perform
> data transformation and real time CDC from Oracle to PostgreSQL. Do
> we have any good open source tool to achieve this with No Coding
> involved.??


You could try debezium, but I don't know how good it works and if it qualifies as "no coding involved"



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

Предыдущее
От: shashidhar Reddy
Дата:
Сообщение: Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Getting error while upgrading postgres from version 12 to 13