Oracle-to-MySQL is an intresting application which helps you to move Oracle databases to MySQL server.
Virtual Server users option:
If you are using Virtual Server hosting you probably have no sufficient privileges to create new databases on the target MySQL server. For this case we recommend the following approach:
· ask your Virtual Server administrator to create blank database for you
· run Oracle-to-MySQL and select this database as the conversion target
· click "Yes" when you will be asked if you'd like to overwrite existing MySQL database
MySQL dump file:
Oracle-to-MySQL converter allows users to do indirect conversion and get more control over the process. Following this way, the program converts Oracle data into a local MySQL dump file instead of moving it to MySQL server directly. This dump file contains MySQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into MySQL database.
Limitations:
· Does not convert views
· Does not convert stored procedures
· Does not convert columns having user-defined types
· Does not allow to connect to Oracle database as SYSDBA or SYSOPER
What's New in This Release:
· Validate installation folder according to Oracle requirements
· Improved support for views