How to import SQL Server data into MongoDB

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