Copy data from multiple SQL Server tables to 1 MongoDB collection

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

Try Withdata DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, Copy SQL Server 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
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Copy data from multiple SQL Server tables to one MongoDB collection

Login to SQL Server.

Login to MongoDB.

Click “Convert Similar Tables” at task dialog.

then show the wizard.

1. Select source SQL Server tables.

2. Choose a destination MongoDB collection and config fields.

3. Set rows options.

4. Copy data from SQL Server to MongoDB.

Click “View”, See MongoDB collection data.

Copy multiple SQL Server tables to one MongoDB collection in command line

Save “SQL Server to MongoDB” session, then you can:

• Copy multiple SQL Server tables to one MongoDB collection in Windows command line.
• Copy multiple SQL Server tables to one MongoDB collection in Linux command line.
• Copy multiple SQL Server tables to one MongoDB collection in macOS command line.

Set scheduled tasks for coping SQL Server data 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:

• Copy data from SQL Server table to MongoDB collection
• Copy data from SQL Server query to MongoDB collection
• Batch copy data from SQL Server tables to MongoDB collections