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@xxxxxxxxxxx> 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 ShafiqSr. DBA
From: Thomas Kellerer <shammat@xxxxxxx>
Sent: Monday, March 20, 2023 7:21 PM
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Oracle to PostgreSQL MigrationInzamam 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"
