Connect MYSQL from ORACLE

Hi

I would like to use mysql as a backup database. May I know how to insert/update changes made from Oracle database to Mysql? Can it be done by Oracle trigger? :confused:

Thanks!

Are there any alternatives? Or it can be done with an open connection from Oracle to mysql? :rolleyes:

Lookup the chapter "Heterogenous services" in your local Oracle-documentation-corner. That'll probably do the trick.

Erik

Thanks! I read up on the distributed database from oracle documentation. It mentioned mostly on database links which only applies for oracle databases.

How do i setup for Mysql database? Any notes or help please? :confused:

Much appreciated! :D

As for me, I would write external function.

What do you mean by external function? How will it be able to detect if there are any changes made in Oracle database before updating them to mysql? :confused:

Does Oracle Heterogeneous Services supports mysql? :rolleyes:

Any more advices please? Many thanks! :)

Quote:

---

Originally posted by mooks
What do you mean by external function? How will it be able to detect if there are any changes made in Oracle database before updating them to mysql? :confused:

---

Create trigger on Oracle table and call this function/procedure from the trigger.
Triger should fire on INS/UPD/DEL.

When calling the external Oracle procedure, it cannot update in mysql database in another server right?

It depends on what your function will do.