Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 27, 2004

Oracle Migration Workbench - Part 1 - Page 2

By Steve Callan

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 3rd 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

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM