Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MySQL

Posted Sep 9, 2004

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

By DatabaseJournal.com Staff

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.



MySQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date