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(dot)shafiq(at)hotmail(dot)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 <shammat(at)gmx(dot)net>
> *Sent:* Monday, March 20, 2023 7:21 PM
> *To:* pgsql-general(at)lists(dot)postgresql(dot)org <
> pgsql-general(at)lists(dot)postgresql(dot)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"
>
>
>
>