Google

Friday, November 14, 2008

Oracle to MySQL

Oracle-to-MySQL is a program to migrate Oracle databases to MySQL server.

Features

  • All Oracle data types (except BFILE and MLSLABEL) and attributes are supported
  • Work with all versions of Unix and Windows MySQL servers
  • Command line support
  • Convert indexes with all necessary attributes
  • Convert foreign keys
  • Merge Oracle data into an existing MySQL database
  • Convert individual tables
  • Exports Oracle databases into MySQL dump file
  • Easy-to-use wizard-style interface
  • Full install/uninstall support

Limitations

  • 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

Requirements

  • At least 32 MB RAM
  • Oracle client and networking components must be installed on the same machine where you run Oracle-to-MySQL from
  • Necessary privileges to write into the destination database