Oracle Migration Workbench - Part 1 - Page 2

Where to get MySQL

Knowing about and using the features available at Oracle Technology Network (OTN) will give you a leg up on navigating your way through MySQL's web site. With minimal effort, you can start downloading MySQL from http://dev.mysql.com/downloads. For Windows, the download (of version 4.0, the current general release) is just over 24MB in size. Just like Oracle, MySQL comes with free documentation. Read on before you start downloading MySQL.

If you want a good, get your feet wet type of book, MySQL Tutorial, published by MySQL Press is certainly a good start. Another book, which combines PHP and MySQL and contains an overview of MySQL database administration, is SitePoint's Build Your Own Database Driven Website Using PHP and MySQL (get the newly released 3^rd edition).

The tutorial book from MySQL Press is very straightforward and will help you install and configure a working MySQL database in short order.

If you are going to download MySQL for use with Oracle Migration Workbench, take note that OMWB supports up to version 3.23 of MySQL. The current version is in the 4.0 series, so you will have to navigate to the archived products section. If you use this link (http://downloads.mysql.com/archives.php?p=mysql-3.23&o=-win), scroll down to the bottom of the page to get the 12.8M 15 Sep 2003 version for Windows (or whichever platform you want to install MySQL on).

Where to Get Oracle Migration Workbench

If you are thinking you already have OMWB because you installed the Enterprise Edition, you are wrong. OMWB is a separate utility you acquire separately from the RDBMS product. Like most every other Oracle product, you can get OMWB from the OTN website (look under Technologies, Utilities, and Drivers heading at http://www.oracle.com/technology/software/index.html, in the middle column about halfway down). I will cover the installation of OMWB in the next article, but if you want to get started on your own, you can take the Quick Tour that comes with this utility.

In Closing

There is a lot of material to cover in this series, but at the end of it, not only will you be familiar with two other widely used and popular database systems, but you will also know how to migrate data from these systems into an Oracle database.

» See All Articles by Columnist Steve Callan