Oracle Migration Workbench - Part 1
October 27, 2004
Let me start with a bad news/good news situation. The bad news: as far as job searches are concerned, it is becoming readily apparent that knowing only Oracle is not good enough anymore. Personally, I have taken major hits for not knowing SQL Server and have heard some static about DB2. The good news: ignorance is curable through education, and if you are somewhat adept with Oracle, learning the mechanics, architecture, and administration of other relational database systems is easy (or easier, anyway). You know there are tables, you know about constraints, and you probably have some coding experience (why do SQL Server people seem to think triggers are the end all and be all of database programming?). In addition, of course, you have dealt with the wicked witches of the East and West (backup/recovery, and performance tuning).
In this series, I will cover two of the "other guys" and go into detail about leveraging what you know about Oracle into quickly assimilating, or at the least, becoming conversant with the details of SQL Server and MySQL. Why those two systems, you may be asking. I believe the reasons for covering SQL Server are fairly obvious, but the selection of MySQL may not be readily apparent. If you are looking at this article via a databasejournal.com link, note the "php" in the URL. The PHP scripting language is frequently used with MySQL and many web sites use a PHP/MySQL combination.
MySQL compares quite favorably against Oracle and SQL Server in terms of speed, performance and scalability. One area where MySQL far exceeds Oracle - in a good way - is in pricing. If not free, depending on your use of MySQL, then you are looking at mere hundreds of dollars in licensing fees as opposed to Oracle's many thousands. The applicability of using databases with web sites is abundantly obvious. How does all of that happen? The "how" of connecting Oracle to a web site via MySQL should be of interest to you. Being able to tie in an Oracle database to a web site via MySQL graduates you from your shrink-wrapped application to deploying your application on the web.
What tools are out there to help you migrate data to (or from) Oracle? The focus of this series is on Oracle's Migration Workbench (OMWB). The product description of OMWB is shown below.
The Oracle Migration Workbench (Migration Workbench) is a tool that simplifies the process of migrating data and applications from non-Oracle databases to Oracle. The Migration Workbench allows you to quickly and easily migrate an entire database (data and schema, including triggers and stored procedures) in an integrated, visual environment. The Migration Workbench employs an intuitive user interface and a series of wizards to simplify the migration process. To ensure portability, all components of the Migration Workbench are written in Java.
Before getting into the details of acquiring, installing, and using OMWB, the remainder of this article will help you get acquainted with MySQL. In Part 2, I'll provide some sample data for a MySQL database that we will use for migrating to an Oracle database. Subsequent parts of this series will cover the same approach for SQL Server.
More about MySQL
If you could look only at the text on Oracle's education/certification pages and the counterpart pages found at MySQL's web site and could not see the name of the product, you almost would not be able to tell the sites apart. At http://www.mysql.com/training/, you see links to training, certification, and partners.
Which web site is this from?
XXXXX regularly offers training courses around the world, in-house training courses, and offers certification for developers who want to prove their expertise in using and deploying XXXXX database products.
XXXXX training courses are delivered regularly all over the world by our expert trainers, who work closely with our team of developers to make sure their students learn everything they need to know about using XXXXX software to the fullest.
And this one?
Our training representatives will work with you to customize solutions to help your work group, department, or global enterprise achieve the results you envision.
The first two quotes are from MySQL, and the third one is from Oracle.
With respect to certification, the motivation for being certified is also similar.
Getting certified with XXXXX can bring you the credibility you deserve for your knowledge, skill, and experience on the job as [a certified user] and will provide you with a market recognized credential that can lead to success.
Certified users of computer software often find that their proven credentials help them get farther in their field, giving their personal careers a boost, and bettering their company's chances of retaining old and getting new customers.
The top quote is from Oracle and the bottom one is from MySQL. Without getting into the merits of certification, spending the time and effort to get certified is worthwhile in and of itself for the simple reason that you are going to learn something (anywhere from a little to a lot) about a product.
Something to consider about becoming proficient in designing and managing database (even if it uses Oracle just a little bit) driven web sites is the potential to work with Oracle even more. Consider this extract from a recent posting on Monster:
...seeking an experienced MySql DBA to work on new projects. This position will involve 50% DBA work with MySql, and 50% split between development, SQL Server, software testing, etc...
And these from Dice:
Seeking strong Data Base Administrator. Will provide support for company's MySQL & Oracle databases on an IBM/Red Hat platform.
We are currently seeking a Junior Database and Systems Developer and Administrator who will develop and maintain database applications, install, maintain and tune Oracle and MySQL databases and UNIX/Linux systems in a distributed environment.
The point of all of this is to state the case that MySQL is used by many organizations in conjunction with Oracle.