I want to migrate my Oracle database to MySqlbut the problem is that my front end is in ORACLE FORMS 10G. I have not been able to find whether I can work with mySQL as backend and Oracle forms as front end ?
If not then what is the reason and possible alternatives? Thanx in advance
Apparently we can configure Oracle Forms to use ODBC. Never done it myself, but I found a guide to doing this with MS Access on OraFAQ. That should be fairly simple to apply to MySQL.
You can try SQLyog's Import external data wizard to migrate your Oracle db to MySQL db. It can import data from any ODBC compliant data source to MySQL. Import external data requires an appropriate Oracle ODBC-driver (matching the data source) installed on the system where SQLyog is running. I prefer this wizard as it can import from various ODBC-compliant data source and can also schedule the import/migration to MySQL using SJA
