| From: | Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com> |
|---|---|
| To: | Thomas Kellerer <shammat(at)gmx(dot)net>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Oracle to PostgreSQL Migration |
| Date: | 2023-03-21 05:36:35 |
| Message-ID: | AM9P251MB0330EA937640B0FF5969520F98819@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dev dyskolos | 2023-03-21 06:59:54 | Missing RHEL8 RPMS |
| Previous Message | Inzamam Shafiq | 2023-03-21 05:34:58 | Re: Oracle to PostgreSQL Migration |