Tips and Tricks

MySQL Migration Toolkit

Relax...it is so easy...

By Adrian Placinta, Web News Editor

31st of August 2007, 14:45 GMT

Adjust text size:

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.

TAGS:

MySQL | Migration Toolkit | Oracle

SEARCH THE NEWS ARCHIVE :

Today's News | Yesterday's News | News Archive

User opinions:

No user comments yet.

Be the first to express your opinion using the form below!

Share your opinion:

SUBMIT PROGRAM \| ADVERTISE \| GET HELP \| SEND US FEEDBACK \| RSS FEEDS \| ENTER NEWS SITE \| ENGLISH BOARD \| ROMANIAN FORUM
© 2001 - 2008 Softpedia. All rights reserved. Softpedia™ and the Softpedia™ logo are registered trademarks of SoftNews NET SRL.	Copyright Information \| Privacy Policy \| Terms of Use \| Update your software \| Archive

NEWS CATEGORIES: