Re: Oracle to PostgreSQL Migration

From: Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com>
To: Umair Shahid <umair(dot)shahid(at)gmail(dot)com>
Cc: 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-24 08:00:37
Message-ID: AM9P251MB0330EFAAC104E7E80C08048F98849@AM9P251MB0330.EURP251.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)shahid(at)gmail(dot)com>
Sent: Tuesday, March 21, 2023 3:48 PM
To: Inzamam Shafiq <inzamam(dot)shafiq(at)hotmail(dot)com>
Cc: 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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2023-03-24 10:28:49 Re: Convert pg_constraint.conkey array to same-order array of column names
Previous Message Bryn Llewellyn 2023-03-23 19:49:34 Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?