SQL Server data import MySQL

Tools/Materials

• Navicat for MySQL

Http://www.cr173.com/soft/38153.html

Method/Step

Create a target database

(note: Because it is a point-to-point data import, the name of the database to be exported in SQL Server is the same as the name of the database to be imported into MySQL)

mysql> create database stddata default  character set gbk collate gbk_chinese_ci; query ok, 1 row affected  (0.17 sec) mysql> show databases;+--------- -----------+| database           |+--------------- -----+| information_schema | |  jiang              | |  mysql              | |  performance_schema | |  stddata            | |  test               |+-------- ------------+6 rows in set  (0.00 sec) 

Click the "Table" item in the website point of the created target database and the Import Wizard option will appear on the right.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/86/42/wKioL1e6cXKCm-D6AACz8QGyNl8289.png-wh_500x0-wm_3 -wmp_4-s_1930221921.png "title=" qq picture 20160822112834.png "alt=" Wkiol1e6cxkcm-d6aacz8qgynl8289.png-wh_50 "/>

Select SQL Server database ODBC, "next", Data Link Properties-sql SERVER ODBC

650) this.width=650; "Src=" http://s4.51cto.com/wyfs02/M01/86/42/wKiom1e6cZOSPlVlAAIPeFybjUI308.png-wh_500x0-wm_ 3-wmp_4-s_2031458799.png "title=" qq picture 20160822112834.png "alt=" Wkiom1e6czosplvlaaipefybjui308.png-wh_50 "/>

650) this.width=650; "Src=" http://s4.51cto.com/wyfs02/M00/86/42/wKiom1e6cfejxfk9AALmQ_wmFKs871.png-wh_500x0-wm_ 3-wmp_4-s_1397717087.png "title=" qq picture 20160822112834.png "alt=" Wkiom1e6cfejxfk9aalmq_wmfks871.png-wh_50 "/>

Create access to SQL SERVER ODBC.

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/86/42/wKiom1e6cw2gemRXAAIaUz4TdXk786.png-wh_500x0-wm_3 -wmp_4-s_262284635.png "title=" qq picture 20160822112834.png "alt=" Wkiom1e6cw2gemrxaaiauz4tdxk786.png-wh_50 "/>

Back in the Import Wizard, you can already see all the tables in the SQL Server source database and select the tables you want to import.

650) this.width=650; "Src=" http://s5.51cto.com/wyfs02/M00/86/42/wKiom1e6c0uxf4oDAACJ2vqgn-s439.png-wh_500x0-wm_ 3-wmp_4-s_255734411.png "title=" qq picture 20160822112834.png "alt=" Wkiom1e6c0uxf4odaacj2vqgn-s439.png-wh_50 "/>

Click Next to see if the data properties of the fields in each table are correct, and if there are problems you can make adjustments (some fields in SQL Server are used the same, but the names are different, note the changes, or the import fails)

650) this.width=650; "Src=" http://s3.51cto.com/wyfs02/M02/86/42/wKioL1e6c5aB3JtLAABiH0NHfpM199.png-wh_500x0-wm_ 3-wmp_4-s_3308686302.png "title=" qq picture 20160822112834.png "alt=" Wkiol1e6c5ab3jtlaabih0nhfpm199.png-wh_50 "/>

650) this.width=650; "Src=" http://s5.51cto.com/wyfs02/M02/86/42/wKioL1e6c_nCEmimAABodCG9XZM493.png-wh_500x0-wm_ 3-wmp_4-s_502079126.png "title=" qq picture 20160822112834.png "alt=" Wkiol1e6c_ncemimaabodcg9xzm493.png-wh_50 "/>

Select "Add"-"Next"-"Start import", OK,

650) this.width=650; "Src=" http://s4.51cto.com/wyfs02/M02/86/42/wKioL1e6dCKggX4hAABz-0T_vPA025.png-wh_500x0-wm_ 3-wmp_4-s_3356329079.png "title=" qq picture 20160822112834.png "alt=" Wkiol1e6dckggx4haabz-0t_vpa025.png-wh_50 "/>

650) this.width=650; "Src=" http://s5.51cto.com/wyfs02/M01/86/42/wKiom1e6dGnDuKOsAABzI_d6Exk168.png-wh_500x0-wm_ 3-wmp_4-s_3709442848.png "title=" qq picture 20160822112834.png "alt=" Wkiom1e6dgndukosaabzi_d6exk168.png-wh_50 "/>

SQL Server data import MySQL