Batch copy data from SQL Server tables to MongoDB Atlas collections without programming

by

Posted on by

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

Using DBToMongo, a native GUI tool, you can batch copy data from SQL Server tables to MongoDB Atlas collections easily and fast.

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

Download 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 file.

2) Set scheduled task for Windows.

More about DBToMongo – the tool to copy SQL Server data to MongoDB Atlas.

30-day free trial Download DBToMongo