Migrating to MySQL

Migration Toolkit for MySQL allows you to migrate data seamlessly from other RDBMS such as MS-SQL, MS-Access and Oracle. It also provides a detailed report at the end of the migration process

Tuesday, October 10, 2006

Print

Comment

Email

Digg

Del.icio.us

Reddit

Twitter

Migrating data to MySQL is quite a difficult task. If you want to migrate data from MS-SQL Server or Oracle to MySQL then you first need to write a SQL script to extract data to a text file and then import the same to MySQL. Here is one migration toolkit that simplifies this process. It takes you step-by-step through a wizard for migrating data including schema objects such as tables and views.

Installation
Install this tool kit using 'mysql-gui-tools-5.0-r3-win32.msi' setup file on your Windows machine and restart it once. Launch the toolkit from Start>programs. You will get a window screen divided in two parts. On the left, you will be shown the entire migration plan, while the wizard on the right can be used to initiate the migration process.

Migrating data
To start migration, click on 'Next' in the right window. On the subsequent screen, select the 'Direct Migration' option and click on Next. Select the source database connection, MS-SQL in this case, and set the source database connection parameters (which include host name, user name and password). 

Click on Next. Now you need to set the target connect parameter, which is your MySQL database (as our MySQL was on the local machine, we selected localhost and gave the required username and password). Click on Next again. Now you will see the entire database inside MS-SQL. For testing the toolkit we selected the 'Northwind.dbo' database (which is the default database with MS-SQL) and clicked on Next twice. Now select the object type that you want to migrate (here deselect MS-SQL View and MS-SQL Routine as selecting these might give errors in the migration process) and click on Next. 

Left pane shows the migration plan while the wizard on the right can be used to initiate the migration process

Now in the next screen you need to change the parameters for 'Migration of type MS-SQL table' by clicking on the 'Set parameters' button. Here you would be shown the parameters that you can change. Select 'Data Consistency/Multilingual' and click on Next. Keep clicking on it till you get the 'Data Mapping option.' Here select Transfer Data Online, which will start the migration process. Once the entire process gets completed, click on Finish. It will show you the data that has been migrated at the end of the entire process, so that you can verify whether it has been migrated successfully or not

Page(s)   1