Batch copy data from SQL Server tables to MongoDB Atlas collections

by

Posted on by

Want to batch copy data from SQL Server tables to MongoDB Atlas collections?

Try Withdata DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, Copy SQL Server data to MongoDB Atlas, Easy and Fast.

  • Step by step, just a few mouse clicks.
  • Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.

Download Withdata DBToMongo Download DBToMongo

Batch copy data from SQL Server tables to MongoDB Atlas collections

Login to SQL Server.

Copy data from SQL Server tables to MongoDB Atlas collections - Login to SQL Server

Login to MongoDB Atlas.

Copy data from SQL Server tables to MongoDB Atlas collections - Login to MongoDB

Click “Convert All Tables” at task dialog.

Import data from SQL Server tables to MongoDB Atlas collections - Task Window

then show the wizard.

1. Select source SQL Server tables.

Convert data from SQL Server tables to MongoDB Atlas collections - open collection

2. Target MongoDB collections, choice “Import Type”.

Extract SQL Server tables data to MongoDB Atlas collections - select table

3. Map SQL Server tables to MongoDB collections.

Import data from relational databases Tables To MongoDB Collections - select tables

4. Summary.

Load data from SQL Server tables to MongoDB Atlas collections - preview

5. Batch copy SQL Server data to MongoDB Atlas.

batch copy data from SQL Server tables to MongoDB Atlas collections - batch copy

Click “View”, See MongoDB Atlas collection data.

Export data from MongoDB Atlas collections to SQL Server table - view collection

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