Copy data from multiple MongoDB collections to 1 SQL Server table without programming

by

Want to copy data from multiple MongoDB collections to a single SQL Server table?

Using MongoToDB, a native GUI tool, you can transfer data from multiple MongoDB collections to 1 SQL Server table 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 MongoToDB Download MongoToDB

Copy data from multiple MongoDB collections to one SQL Server table

Login to MongoDB.

Copy data from multiple MongoDB collections to 1 SQL Server table - Login to MongoDB

Login to SQL Server.

Copy data from multiple MongoDB collections to 1 SQL Server table - Login to SQL Server

Click “Import Similar Collections” at task dialog.

Import data from multiple MongoDB collections to 1 SQL Server table - Task Window

then show the wizard.

1. Select MongoDB Collections.

Convert data from multiple MongoDB collections to 1 SQL Server table - select collections

2. Choose destination SQL Server table and config fields.

Extract multiple MongoDB collections data to 1 SQL Server table - choose table

3. Preview data.

Load data from multiple MongoDB collections to 1 SQL Server table - preview

4. Copy MongoDB data to SQL Server.

Transfer data from multiple MongoDB collections to 1 SQL Server table - Transfer

Click “View”, See SQL Server table data.

Export data from multiple MongoDB collections to SQL Server  table - view table

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task for Windows.


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

30-day free trial Download MongoToDB