How to Convert/Migrate/Move/Copy MSSQL Database to MySQL Database?

Amplify’d from eitwebguru.com

Scenario

Your Company/Organization/Institute maintains certain data in MSSQL 2000 but now on suggestion of System Analyst or database administrator you want to move the data to MySQL 5.x.

Questions? 1) How to migrate the data? 2) Do we need to recreate the complete database schema? 3) Can we use any third Party Application to convert it and how feasible it will be? etc.

Solution

Using following steps you can easily move/convert the data from MSSQL to MySql (Only data will be moved).

Downloads Required Tools

1) MySql ODBC connector: MySQL ODBC Connector will help Windows OS to configure MySQL as Database Source Name (DSN). It can be downloaded from http://dev.mysql.com/downloads/connector/odbc/5.1.htm

Install MySql ODBC connector on the Server.

Installation of MySql ODBC connector is pretty easy. You will just have to run setup file and follow the instructions.

Configure MySQL Database Source Name (DSN)

Database Source Name or DSN specifies a data structure that contains the information about a specific data source or database that an Open Database Connectivity (ODBC) driver needs in order to connect to that data source or database. To add new DSN follow the instructions given below

1) Go to “Control Panel -> Administrative Tools -> Data Source” which will open following windows.

Click on “Add…” to add new DSN Read more at eitwebguru.com

 

See this Amp at http://amplify.com/u/a12ljs