Export MongoDB query results to MySQL table without programming

by

Posted on by

Want to transfer data from MongoDB query results to MySQL table?

Using MongoToDB, a native GUI tool, you can transfer data from MongoDB query results to MySQL table easily and fast, just a few mouse clicks!

Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.

Support Windows, Linux, macOS

Support connect to MySQL through SSH tunnel.

Here you can download and install MongoToDB.

Transfer data from MongoDB query To MySQL table

Click “Wizard – Import From Query” at task dialog.

Import data from MongoDB query results to MySQL table - Task Window

then show the wizard.

1. Set a MongoDB query.

Convert data from MongoDB query results to MySQL table - open query results

2. Select a destination table and config fields.

Extract MongoDB query results data to MySQL table - select table

3. Preview data.

Load data from MongoDB query results to MySQL table - preview

4. Transfer.

Transfer data from MongoDB query results to MySQL table - Transfer

Click “View”, See MySQL table data.

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

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

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

30-day free trial Download MongoToDB