Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

Convert Oracle to MySQL Database

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Convert Oracle-to-MySQL | Developers Site

Oracle-to-MySQL is a program to move Oracle databases to MySQL server. Depending on your privileges on the target MySQL server you can export Oracle data into new database or overwrite the contents of an existing MySQL database. All Oracle data types and attributes are supported. The program works with all versions of Unix and Windows MySQL servers.

Oracle to MySQL Database Features

  • All Oracle data types (except BFILE and MLSLABEL) and attributes are supported
  • Works with all versions of Unix and Windows MySQL servers
  • Command line support
  • Converts indexes with all necessary attributes
  • Merges Oracle data into an existing MySQL database
  • Converts individual tables
  • VServer user's option
  • Exports Oracle databases into a dump file
  • Easy-to-use wizard-style interface
  • Full install/uninstall support

Oracle to MySQL Database Limitations

  • Does not convert foreign keys
  • 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

Oracle to MySQL Database Requirements

  • Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
  • At least 32 MB of available memory
  • Oracle client and networking components should be installed on the same machine where you run Oracle-to-MySQL from

Oracle to MySQL Database VServer user's 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:

  1. ask your Virtual Server administrator to create blank database for you
  2. run Oracle-to-MySQL and select this database as the conversion target
  3. click "Yes" when you will be asked if you'd like to overwrite existing MySQL database

When you complete these steps, the entire contents of the source MS SQL database will be imported into the specified MySQL database.

Oracle to MySQL Database MySQL dump file

Oracle-to-MySQL allows users to perform deferred conversion and get more control over the process. Following this way, the program stores the contents of the source database into a local dump file instead of moving it to MySQL server directly. The resulting file contains MySQL statements to create all tables and to fill them with the data. You will be able to import this file into existing MySQL database via MySQL client as follows:

mysql.exe --host=... --user=... --password=... -vvf {MySQL database name} < {dump file name}

Screen Shot

Oracle to MySQL - a program to move Oracle databases to MySQL server

Oracle to MySQL Migration $49.00  Payment Problems & Options SAVE by buying SQL Migration Toolkit Software | Developers Site

License Type:
Two Products Bundle #1
order Oracle-to-MySQL + Access-to-MySQL , SAVE!
$58.50 ORDER NOW
Two Products Bundle #2
order Oracle-to-MySQL + MSSQL-to-MySQL , SAVE!
$73.50 ORDER NOW

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS