Copy data from MySQL query to MongoDB collection

by

Posted on by

Want to copy data from MySQL query results to MongoDB collection?

Try Withdata DBToMongo, a MySQL to MongoDB converter for Windows, MacOS, and Linux, Copy MySQL query 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.

Download Withdata DBToMongo Download DBToMongo

Copy data from MySQL query results To MongoDB collection

Login to MySQL.

Copy data from MySQL query to MongoDB collection - Login to MySQL

Login to MongoDB.

Copy data from MySQL query to MongoDB collection - Login to MongoDB

Click “Convert From Query” at task dialog.

Export data from MySQL query results to MongoDB collection - Task Window

then show the wizard.

1. Enter source MySQL query.

Convert data from MySQL query to MongoDB collection - enter query

2. Choose destination MongoDB collection and config fields.

Extract MongoDB query data to MySQL collection - select collection

3. Set rows options.

Load data from MySQL query to MongoDB collection - preview

4. Export MySQL query results to MongoDB collection.

Transfer data from MySQL query to MongoDB collection - export

Click “View”, See MongoDB collection data.

Export data from MySQL (MariaDB, Percona) to MongoDB - view collection

Copy data from MySQL query results to MongoDB in command line

Save “MySQL query to MongoDB” session, then you can:

Set scheduled tasks for coping data from MySQL query results to MongoDB

You can schedule and automate this converting task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “MySQL to MongoDB” conversion.
  2. Set scheduled task for “MySQL to MongoDB” conversion.

FAQ

More about Withdata DBToMongo – MySQL to MongoDB Converter

See also: