This is a little left field… but we’ve migrated a lot of onprem oracle
databases to Postgres (on aws rds) using aws database migration service -
which has worked very well and supports cdc.
I do wonder if you did the above and then add a 2nd cdc out from Postgres
rds to your onprem Postgres.
So
On Fri, 2023-03-24 at 08:00 +, Inzamam Shafiq wrote:
> 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.
In addition to the commercial tools that Christophe
> 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.??
To meet
, 2023 3:48 PM
To: Inzamam Shafiq
Cc: Thomas Kellerer ; pgsql-general@lists.postgresql.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 the
gt;
> On Mon, Mar 20, 2023 at 1:58 PM Inzamam Shafiq
> wrote:
>
>> Hi,
>>
>> Hope everyone is fine.
>>
>> Can someone help or guide regarding Open Source tools for Oracle to
>> PostgreSQL migration with real time CDC. along with this is there any
>>
t; time ?
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Mon, Mar 20, 2023 at 1:58 PM Inzamam Shafiq
wrote:
> Hi,
>
> Hope everyone is fine.
>
> Can someone help or guide regarding Open Source tools for Oracle to
> PostgreSQL migration with real time CDC. along wi
ave 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*
> --
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
?
Regards,
Inzamam Shafiq
Sr. DBA
From: Ron Johnson
Sent: Monday, March 20, 2023 7:15 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Oracle to PostgreSQL Migration
Real-time CDC is the difficult part. ora2pg (using views) can do a static
migration. No coding
On Mon, Mar 20, 2023 at 10:21 AM Thomas Kellerer wrote:
> 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
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
wrote:
> Hi,
>
> Hope everyone is fine.
>
> Can someone help or guide regarding Open Source tools for Oracle to
> PostgreSQL migration with real time CDC. along with this is there any
> possibility to change the structure of the database? Let me explain a
> little more,
Hi,
Hope everyone is fine.
Can someone help or guide regarding Open Source tools for Oracle to PostgreSQL
migration with real time CDC. along with this is there any possibility to
change the structure of the database? Let me explain a little more,
We have an Oracle DB which is around 1TB
On Thu, 2022-02-03 at 20:24 +0530, Rama Krishnan wrote:
> How do we take care of database character set when trying
> to migrate from oracle to postgres
If NLS_SORT and NLS_COMP are set to German in Oracle,
just create the PostgreSQL to a German collation to get
a similar behavior.
Yours,
14 matches
Mail list logo
