Data imported from Mmsql to MySQL

SQL Server data import MySQL

Tools: Navicat for MySQL Baidu search an installation can, if you have installed MySQL

1, create the target database

Click on the Create a good target database website point table One item, on the right side of the Import wizard will appear

Select ODBC in the Import Wizard and click Next

3. Create the correct SQL Server database ODBC

Next, Data link Properties-sql SERVER ODBC

Next create access to SQL SERVER ODBC and test successful connection properties

4. Import via Navicat Software Import Tool

Next, go back to the Import Wizard and find that you can view all the tables in the SQL Server source database, select the tables you want to import, and I'll test all of them here.

Click Next to see if the data properties of the fields in each table are correct, and you can adjust them if you have problems

Next

Start Import

Message prompt import successful, click the Close button

This has been successfully imported to MySQL.

SQLSERVER2005 solutions that are not accessible externally:

1. Open the start-up program->microsoft SQL Server 2005-> Configuration tool->sql Server surface Area Configuration
2. On the SQL Server 2005 Surface Area Configuration page, click the surface area Configuration for services and connections
3. Then click to expand Database Engine, select Remote connection, and on the right, select Local Area Connection and remote connection.
Then select the protocol you want to use (this place should enable the TCP/IP and Named Pipes service!). Click "Apply" and you will see the following message:
"Changes made to the connection settings will not take effect until the Database engine service is restarted. , click the OK button to return
4. Expand Database Engine, select Services, click Stop on the right, and wait until the MSSQLSERVER service stops.
Then click Start to restart the MSSQLServer service.