by October 9, 2006 0 comments

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

Database administrators
Data migration from any database to MySQL 
Data Migration tool for MySQL
PCQ Xtreme\system\labs

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

No Comments so far

Jump into a conversation

No Comments Yet!

You can be the one to start a conversation.