MySQL Migration Toolkit

One of the biggest problems of a database administrator is migrating from a proprietary database to MySQL. Using MySQL Migration Toolkit you can migrate from Microsoft SQL Server, Oracle, Microsoft Access, Sybase databases to MySQL database quickly and without problems.

You can find Mysql Migration toolkit in MySQL GUI tools. Install Mysql GUI Tools and to run properly MySQL Migration Toolkit you must install JRE 1.5.0 update 8. To migrate to MySQL, you will have to make 8 steps.

When you run for the first time MySQL Migration Toolkit it will verify if the startup requirements have been meet. If you choose Direct Migration you must install Migration Toolkit on the source or the target machine. If Migration toolkit is not installed on one of these 2 machines, there will be a huge network traffic overhead. After that choose the source database you migrate from, set the source connection parameter and also choose the target database connection (that will be MySQL 5.0) and the connection parameters.

The second step is to select the schemata that will have to be migrated. Then choose the migration method and the parameters. If you encounter problems with the mapping, you can manually edit the generated objects. In the fifth step you will select the desired one for the object creation: create objects online (create the objects on the target machine) and create script file for create statements (check this option if you want to store the object creation in a script file). In the next step you will set the data transformations and column mappings. After that configure server-side bulk data transfer and the procedure is over. The last screen shows the report of the migration process that provides detailed information about the number of objects (tables, views, etc) that have been migrated.

I hope this guide will help you make your database migration easier.