To import SQL Server data into MongoDB using Mongovue _mssql

First, train of thought

Mongovue free version support MySQL import MONGO, so the idea is that SQL Server import MySQL, and then import MONGO from MySQL.

Second, prepare

1, install MySQL database (I am using Wamp, integrated mysql,phpadmin), if necessary, build your own database such as MyData

2, download Mysql-connector-odbc-5.1.12-win32.msi, install

3, Start---> admin tools---> Data source (ODBC)---> User DSN, add MySQL ODBC 5.1 Driver

4, in SQL Server object, linked server, right key new

5, in the MySQL database to build the table to import data, such as table name is T

6. Write import SQL statements in SQL Server such as INSERT into OPENQUERY (MySQL, ' select * from t ') select * from t

7, using Mongovue to import data in MySQL

Wait.... Complete!

Pay attention.

1,sqlserver Don't use window authentication

2, the Chinese text segment to use the MySQL gb2312 collation

3,mssql bit to be modified to MySQL tinyint (1), MSSQL tinyint-->mysql int,mssql varchar (max)-->mysql text and cannot be the last field (practice proves , I also puzzled, if is the last one, the first column ID column inserts all is 0)