|
Oracle-to-MySQL
is a program to migrate 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.
Oracle-to-MySQL 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
- Converts foreign keys
- Merges Oracle data into an
existing MySQL database
- Converts individual tables
- VServer user's option (see
below)
- Exports Oracle databases
into MySQL dump file (see below)
- Easy-to-use wizard-style
interface
- Full install/uninstall
support
Oracle-to-MySQL 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
Oracle-to-MySQL System 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 must be installed on the same machine
where you run Oracle-to-MySQL from
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:
- 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
When you
complete these steps, the entire contents of the source MS SQL
database will be imported into the specified 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} |
