Re: Oracle to PostgreSQL Migration - Mailing list pgsql-general

From Inzamam Shafiq
Subject Re: Oracle to PostgreSQL Migration
Date
Msg-id AM9P251MB0330EA937640B0FF5969520F98819@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Oracle to PostgreSQL Migration  (Thomas Kellerer <shammat@gmx.net>)
Responses Re: Oracle to PostgreSQL Migration  (Umair Shahid <umair.shahid@gmail.com>)
List pgsql-general
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 by date:

Previous
From: Inzamam Shafiq
Date:
Subject: Re: Oracle to PostgreSQL Migration
Next
From: dev dyskolos
Date:
Subject: Missing RHEL8 RPMS