Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle to PostgreSQL Migration - Mailing list pgsql-general

From Umair Shahid
Subject Re: Oracle to PostgreSQL Migration
Date
Msg-id CAM184AcqyTEHXJXdJYjzdfzDv9mLTWT+6F=j2eLt-uz_jca2eA@mail.gmail.com
Whole thread Raw
In response to Re: Oracle to PostgreSQL Migration  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
Responses Re: Oracle to PostgreSQL Migration  (Inzamam Shafiq <inzamam.shafiq@hotmail.com>)
List pgsql-general
Tree view
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 Shafiq
Sr. DBA
From: 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 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"



pgsql-general by date:

Previous
From: shashidhar Reddy
Date:
Subject: Re: Re[2]: Getting error while upgrading postgres from version 12 to 13
Next
From: Adrian Klaver
Date:
Subject: Re: Getting error while upgrading postgres from version 12 to 13