Copy data from multiple MySQL tables to 1 MongoDB collection

by

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.

Download Withdata DBToMongo Download DBToMongo

Copy data from multiple MySQL tables to one MongoDB collection

Login to MySQL.

Copy data from multiple MySQL tables to 1 MongoDB collection - Login to MySQL

Login to MongoDB.

Copy data from multiple MySQL tables to 1 MongoDB collection - Login to MongoDB

Click “Convert Similar Tables” at task dialog.

Import data from multiple MySQL tables to 1 MongoDB collection - Task Window

then show the wizard.

1. Select source MySQL tables.

Convert data from multiple MySQL tables to 1 MongoDB collection - select tables

2. Choose a destination MongoDB collection and config fields.

Extract multiple MySQL tables data to 1 MongoDB collection - choose collection

3. Set rows options.

Load data from multiple MySQL tables to 1 MongoDB collection - preview

4. Copy data from MySQL to MongoDB.

Transfer data from multiple MySQL tables to 1 MongoDB collection - Transfer

Click “View”, See MongoDB collection data.

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

Copy multiple MySQL tables to one MongoDB collection in command line

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

Set scheduled tasks for coping MySQL data 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 DBToMongoMySQL to MongoDB Converter

See also: