Want to copy data from multiple MongoDB collections to a single SQL Server table?
Using MongoToDB, a MongoDB to SQL Server converter for Windows, MacOS, and Linux, you can transfer data from multiple MongoDB collections to 1 SQL Server table easily 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.
Copy data from multiple MongoDB collections to one SQL Server table
Login to MongoDB.
Login to SQL Server.
Click “Import Similar Collections” at task dialog.
then show the wizard.
1. Select MongoDB Collections.
2. Choose destination SQL Server table and config fields.
3. Preview data.
4. Copy MongoDB data to SQL Server.
Click “View”, See SQL Server table data.
Copy data from multiple MongoDB collections to 1 SQL Server table in command line
Save “MongoDB to SQL Server” session, then you can:
- Copy data from multiple MongoDB collections to 1 SQL Server table in Windows command line.
- Copy data from multiple MongoDB collections to 1 SQL Server table in Linux command line.
- Copy data from multiple MongoDB collections to 1 SQL Server table in macOS command line.
Set scheduled tasks for coping data from multiple MongoDB collections to 1 SQL Server table
You can schedule and automate this “MongoDB to SQL Server” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.