Data migration of MS SQL to MySQL
Click the
Import Wizard in the Table View.
Click for larger image
From the list
of file formats available, choose ODBC.
Click for larger image
Click the
browse button to list the available ODBC sources.
In the
Provider tab, choose "Microsoft OLE DB Provider for SQL Server"
In the
Connection tab, enter the server address, username and password of the connection.
After the correct information has been entered, you will be able to see the
available databases on the server from the pull down list.
After you have
confirmed your settings, you will see the tables of the chosen database in the Navicat
Import Wizard, Step 2.
Navicat will
make some guesses on your table's field types; you can always change it. Please
note that from Step 2 to Step 6, the import wizard will take a couple of
seconds to load, depending on your database size and connection speed.
Normally, it will finish loading within one minute.
Click Execute
to start the Import.
Import has
finished successfully.
Click for larger image
With
the help of Navicat, transferring data from MS SQL to MySQL is a piece of cake.
Navicat not only helps to migrate data from MS SQL to MySQL, it also helps
generate reports, exports files to various file types and many other basic
database administration options.
Conclusion
My
intention here is to point out how MySQL is advantageous over MS SQL in the
aspect of its openness. In addition, I have illustrated how easy MS SQL data
can be migrated to MySQL with Navicat. Open source has substantial advantages
that will be recognized by more and more people with time.
» 
IE 7
Firefox 2.0
Comment and Contribute
