Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command

Oracle Goldengate supports Oracle to PostgreSQL migrations by supporting PostgreSQL as a target database, though reverse migration i.e PostgreSQL to Oracle is not supported. One of the key aspect of these database migrations is initial data load phase where full tables data have to copied to the target datastore. This can be a time consuming…

GoldenGate Setup for Real-Time Data Synchronization

In this post we discussed about GoldenGate(GG) concepts and setting GG without DataPump Process. Now I will talk about DataPump process and show how to setup GG replication which also uses DataPump. In GG environment, extract process will write the data to local trail files and then pump process reads from this local trail file…

AskDba.org Weblog

Writing our experiences with AWS, Oracle, PostgreSQL

Tag Archives: GoldenGate

Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command

GoldenGate Setup for Real-Time Data Synchronization