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