Want to copy data from multiple MySQL tables to a single MongoDB collection?
Try Withdata DBToMongo, a MySQL to MongoDB converter for Windows, MacOS, and Linux, Copy MySQL 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.
Copy data from multiple MySQL tables to one MongoDB collection
Login to MySQL.
Login to MongoDB.
Click “Convert Similar Tables” at task dialog.
then show the wizard.
1. Select source MySQL tables.
2. Choose a destination MongoDB collection and config fields.
3. Set rows options.
4. Copy data from MySQL to MongoDB.
Click “View”, See MongoDB collection data.
Copy multiple MySQL tables to one MongoDB collection in command line
Save “MySQL to MongoDB” session, then you can:
- Copy multiple MySQL tables to one MongoDB collection in Windows command line.
- Copy multiple MySQL tables to one MongoDB collection in Linux command line.
- Copy multiple MySQL tables to one MongoDB collection in macOS command line.
Set scheduled tasks for coping MySQL data to MongoDB
You can schedule and automate this converting task by:
- Save session and create .bat (Windows) or .sh (Linux/macOS) file for “MySQL to MongoDB” conversion.
- Set scheduled task for “MySQL to MongoDB” conversion.
FAQ
More about Withdata DBToMongo – MySQL to MongoDB Converter
See also: