Copy data from SQL Server query to MongoDB collection without programming

by

Posted on by

Want to copy data from SQL Server query results to MongoDB collection?

Using DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, you can transfer data from SQL Server query to MongoDB collection easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.

Download DBToMongo Download DBToMongo

Copy data from SQL Server query results To MongoDB collection

Login to SQL Server.

Copy data from SQL Server query to MongoDB collection - Login to SQL Server

Login to MongoDB.

Copy data from SQL Server query to MongoDB collection - Login to MongoDB

Click “Convert From Query” at task dialog.

Export data from SQL Server query results to MongoDB collection - Task Window

then show the wizard.

1. Enter source SQL Server query.

Convert data from SQL Server query to MongoDB collection - enter query

2. Choose destination MongoDB collection and config fields.

Extract MongoDB query data to SQL Server collection - select collection

3. Summary.

Load data from SQL Server query to MongoDB collection - preview

4. Export SQL Server query results to MongoDB collection.

Transfer data from SQL Server query to MongoDB collection - export

Click “View”, See MongoDB collection data.

Export data from SQL Server to MongoDB - view collection

Copy data from SQL Server query results to MongoDB in command line

Save “SQL Server query to MongoDB” session, then you can:

Set scheduled tasks for coping data from SQL Server query results to MongoDB

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task for Windows.

FAQ

More about DBToMongo – SQL Server to MongoDB Converter