Convert existing Oracle database to a more flexible format under the MySQL format, have data integrated automatically, or use profile sets to customize the conversion process.
- Oracle to MySQL
- Version :6.1.7.1
- License :Demo
- OS :Windows All
- Publisher :hlevelsoft
Oracle to MySQL Description
Oracle to MySQL is an application designed to offer the possibility to convert databases built using the Oracle service into the MySQL format, with options for integration in corresponding servers. The overall process is wizard driven, with each step fitted with descriptions and info fields that need to be filled in accordingly.
The application only targets Oracle databases to be transformed into MySQL, and not the other way around. The process can be used from the command line utility for batch processing. Conversion data benefits from filter support via Select queries.
Databases are grabbed from both conventional and virtual server environments, where privilege limitations might not allow the creation of new databases. For virtual server environments, a blank database needs to be created, after which data is migrated using the application’s features.
Custom conversion can be done, as an alternative to the direct, conventional move process of the Oracle database to MySQL server. This is done through a dump file created by the application, with all data fields stored there, thus deferring conversion to provide more control over the process.
There’s built-in support for existing profile settings that determine the functionality of the conversion process. This enables conversion customization by skipping indexes, making all strings case sensitive, show tables owned by the user, or conversion of table definitions only.
System requirements
- 32MB RAM
- Oracle client and networking components
- Necessary privileges to write into the destination database
Limitations in the unregistered version
- 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