Re: Oracle to PostgreSQL Migration
| От | Umair Shahid |
|---|---|
| Тема | Re: Oracle to PostgreSQL Migration |
| Дата | |
| Msg-id | CAM184AcqyTEHXJXdJYjzdfzDv9mLTWT+6F=j2eLt-uz_jca2eA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Oracle to PostgreSQL Migration (Inzamam Shafiq <inzamam.shafiq@hotmail.com>) |
| Ответы |
Re: Oracle to PostgreSQL Migration
|
| Список | pgsql-general |
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.
- Umair
On Tue, Mar 21, 2023 at 10:36 AM Inzamam Shafiq <inzamam.shafiq@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 ShafiqSr. DBAFrom: Thomas Kellerer <shammat@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 MigrationInzamam 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"
В списке pgsql-general по дате отправления: