Hi Umair, 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.sha...@gmail.com> Sent: Tuesday, March 21, 2023 3:48 PM To: Inzamam Shafiq <inzamam.sha...@hotmail.com> Cc: Thomas Kellerer <sham...@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org> Subject: Re: Oracle to PostgreSQL Migration Could oracle_fdw<https://github.com/laurenz/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.sha...@hotmail.com<mailto:inzamam.sha...@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 <sham...@gmx.net<mailto:sham...@gmx.net>> Sent: Monday, March 20, 2023 7:21 PM To: pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> <pgsql-general@lists.postgresql.org<mailto: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"
