Oracle to mysql database mirroring

Question

We are using ERP application that stores data to ORACLE database and also we have web applications that uses the same ERP database. We are getting the performance issues when ERP and another application use the same database.

We are planning to do mirroring of oracle database into mysql database. So that mysql db is used for web applications and oracle db is used for ERP. So we could say these new database (mysql) are mirror of ERP database.

What is the best way for mirroring this condition?

Answer 1

You could use Golden Gate for this kind op replication. See GoldenGate for Oracle to MySQL A VERY smart alternative - and very price worthy - would be dbvisit replicate The Dedicated Dbvisit Server : Replicating Data from Oracle to MySQL and SQL Server