Copy data from multiple MongoDB collections to 1 MySQL table without programming

by

Want to copy data from multiple MongoDB collections to a single MySQL table?

Using MongoToDB, a native GUI tool, you can transfer data from multiple MongoDB collections to 1 MySQL table 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 MongoToDB Download MongoToDB

Copy data from multiple MongoDB collections to one MySQL table

Login to MongoDB.

Copy data from multiple MongoDB collections to 1 MySQL table - Login to MongoDB

Login to MySQL.

Copy data from multiple MongoDB collections to 1 MySQL table - Login to MySQL

Click “Import Similar Collections” at task dialog.

Import data from multiple MongoDB collections to 1 MySQL table - Task Window

then show the wizard.

1. Select MongoDB Collections.

Convert data from multiple MongoDB collections to 1 MySQL table - select collections

2. Choose destination MySQL table and config fields.

Extract multiple MongoDB collections data to 1 MySQL table - choose table

3. Preview data.

Load data from multiple MongoDB collections to 1 MySQL table - preview

4. Copy MongoDB data to MySQL.

Transfer data from multiple MongoDB collections to 1 MySQL table - Transfer

Click “View”, See MySQL table data.

Export data from multiple MongoDB collections to MySQL  (MariaDB, Percona) table - view table

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task for Windows.


More about MongoToDB – the tool to copy MongoDB data to MySQL.

30-day free trial Download MongoToDB