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
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 al
ch 21, 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 an
EDB has migration toolkit , which is very helpful in migration from Oracle
to EDB.
Thanks and Regards
Paramjib Baruah
On Tue, Mar 21, 2023 at 9:12 PM Marc Millas wrote:
> EDB do have a replication server which can be used to transfer real time
> data from oracle to postgres.
> don't know if it
EDB do have a replication server which can be used to transfer real time
data from oracle to postgres.
don't know if it can be used to get to "no downtime"
BTW what do you call "no downtime" as anyway a switch, as fast as it can be
do take ""some"" time ?
Marc MILLAS
Senior Architect
+33607850334
> *From:* Thomas Kellerer
> *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 a
Kellerer
Sent: Monday, March 20, 2023 7:21 PM
To: 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,
?
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 Orac
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 achiev
Real-time CDC is the difficult part. ora2pg (using views) can do a static
migration. No coding (unless you consider clever use of bash to modify
config files to be coding). I used it to migrate a 7TB db to Postgresql.
https://ora2pg.darold.net/
On Mon, Mar 20, 2023 at 8:58 AM Inzamam Shafiq
w
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,
Laurenz
13 matches
Mail list logo
