Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we have to schedule jobs to insert data in actual schema from foreign tables, so some delay might be there.
Regards,
Inzamam Shafiq
From: Umair Shahid <umair.shahid@gmail.com> Sent: Tuesday, March 21, 2023 3:48 PM To: Inzamam Shafiq <inzamam.shafiq@hotmail.com> Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org> Subject: Re: Oracle to PostgreSQL Migration
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.
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?
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"