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

From Inzamam Shafiq
Subject Re: Oracle to PostgreSQL Migration
Date
Msg-id AM9P251MB0330EFAAC104E7E80C08048F98849@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Oracle to PostgreSQL Migration  (Umair Shahid <umair.shahid@gmail.com>)
Responses Re: Oracle to PostgreSQL Migration  (Christophe Pettus <xof@thebuild.com>)
Re: Oracle to PostgreSQL Migration  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hi Umair,

Thanks, oracle_fdw can be used, but it doesn't provide real time sync, we have to schedule jobs to insert data in actual schema from foreign tables, so some delay might be there.

Regards,

Inzamam Shafiq

From: Umair Shahid <umair.shahid@gmail.com>
Sent: Tuesday, March 21, 2023 3:48 PM
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Oracle to PostgreSQL Migration
 
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: Bryn Llewellyn
Date:
Subject: Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?
Next
From: Dominique Devienne
Date:
Subject: Re: Convert pg_constraint.conkey array to same-order array of column names