Copy data from multiple SQL Server tables to 1 MongoDB collection without programming

by

Want to copy data from multiple SQL Server tables to a single MongoDB collection?

Using DBToMongo, a native GUI tool, you can transfer data from multiple SQL Server tables to 1 MongoDB collection 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

Copy data from multiple SQL Server tables to one MongoDB collection

Login to SQL Server.

Copy data from multiple SQL Server tables to 1 MongoDB collection - Login to SQL Server

Login to MongoDB.

Copy data from multiple SQL Server tables to 1 MongoDB collection - Login to MongoDB

Click “Convert Similar Tables” at task dialog.

Import data from multiple SQL Server tables to 1 MongoDB collection - Task Window

then show the wizard.

1. Select source SQL Server tables.

Convert data from multiple SQL Server tables to 1 MongoDB collection - select tables

2. Choose a destination MongoDB collection and config fields.

Extract multiple SQL Server tables data to 1 MongoDB collection - choose collection

3. Summary.

Load data from multiple SQL Server tables to 1 MongoDB collection - preview

4. Copy data from SQL Server to MongoDB.

Transfer data from multiple SQL Server tables to 1 MongoDB collection - Transfer

Click “View”, See MongoDB collection data.

Export data from multiple MongoDB 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.

30-day free trial Download DBToMongo