Re: Oracle to PostgreSQL Migration
paramjib baruah <paramjibbaruah@gmail.com>
From: paramjib baruah <paramjibbaruah@gmail.com>
To: Marc Millas <marc.millas@mokadb.com>
Cc: Inzamam Shafiq <inzamam.shafiq@hotmail.com>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-03-22T05:27:59Z
Lists: pgsql-general
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 <marc.millas@mokadb.com> 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 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 > www.mokadb.com > > > > On Mon, Mar 20, 2023 at 1:58 PM Inzamam Shafiq <inzamam.shafiq@hotmail.com> > 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, >> >> 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.?? >> >> Thanks. >> >> Regards, >> >> *Inzamam Shafiq* >> *Sr. DBA* >> >