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> 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> > *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" > > > >
