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 <inzamam.sha...@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* >
