dcsimg

The Era of Open Source: Migrate your Data from MS SQL to MySQL - Page 2

September 9, 2004

Data migration of MS SQL to MySQL

  • Click the Import Wizard in the Table View.

    Click for larger image
    Table View



  • From the list of file formats available, choose ODBC.

    Click for larger image
    Import Wizard View, Step 1

  • Click the browse button to list the available ODBC sources.

    Import Wizard View, Step 2


  • 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.

    Import Wizard View, Step 2, filled out


  • 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.

    Import Wizard View, Step 6


  • Click Execute to start the Import.

    Import Wizard View, Step 10


  • Import has finished successfully.

    Import Wizard View, Finished screen

    Click for larger image
    Navicat 2004, directory screen

    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.