Copy data from SQL Server query to MongoDB collection

by

Posted on by

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

Try Withdata DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, Copy SQL Server query data to MongoDB, Easy 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 Withdata 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. Set rows options.

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 (Windows) or .sh (Linux/macOS) file for “SQL Server to MongoDB” conversion.
  2. Set scheduled task for “SQL Server to MongoDB” conversion.

FAQ

More about Withdata DBToMongo – SQL Server to MongoDB Converter

See also: