Convert SQL Server database to MySQL database

1. First install sqlserver2005 or another version. Taking sqlserver2005 as an example, the XP system only supports sqlserver2005 development edition and individual edition 2008.

2. Import the database file backed up by sqlserver to sqlserver2005. SQL for opening an instance
Server Management studio click connection -- Right-click Database -- Select Restore database, and click the option path must be correct. Then go to the Shiyan database and there will be a table file.

3. Install ODBC at http://download.csdn.net/detail/daotianmi/3670315download.

4. Configure ODBC
.

Programmer Control Panel administrator data source (ODBC)

Click Add a chart (2) to create a new data source

Select miicrosoft paradax-Treiber (*. DB). Click Finish. Add Data Source Name: shjyt (3 ))
Click Select Directory select D: \ Program Files \ kn \ Shanghai data db_dbf System \ data (that is, the installation path)
À OK. ODBC configuration is complete.

For example, you must note that the MySQL database encoding must be consistent with the SQL Server database encoding. If the encoding is UTF-8, right-click UTF-8 and choose "ODBC" from the shortcut menu.

Select Microsoft ole db provider for SQL Server
Click Next. This is the sqlserver database created in step 2. Click test connection to check whether the connection is successful. If yes, click OK.

There will be several tables for you to select, select, convert, and click Next. You will know that there is a start button, click Start, and click Close. Then you can see that there is a table file in the MySQL Shiyan database. The conversion format may be inconsistent, and some primary key settings are not converted. You need to manually enter them for comparison.