Withdata Software

Percona to MongoDB - Copy Data Without Programming in Linux

Sometimes you need to copy Percona data to MongoDB, you can use Withdata DBToMongo as Percona to MongoDB Copier (Converter / Transferor).

"Percona to MongoDB" tool - DBToMongo

Works GREAT on Windows, Mac and Linux.

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

Can run in GUI mode, Step by Step, just a few mouse clicks.

  1. Query to Collection - Copy data from Percona query to MongoDB collection
  2. 1 to 1 - Copy data from Percona table to MongoDB collection
  3. n to 1 - Copy data from multiple Percona tables to 1 MongoDB collection
  4. n to n - Batch copy data from Percona tables to MongoDB collections

Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.



Download Withdata DBToMongoDownload DBToMongo



Start Withdata DBToMongo.

Login to Percona.

Copy data from Percona to MongoDB - Login to Percona

Login to MongoDB.

Copy data from Percona to MongoDB - Login to MongoDB



Query Results to Collection

Click "Convert From Query" at task dialog.

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

then show the wizard.

1. Enter source Percona query.

Convert data from Percona query to MongoDB collection - enter query

2. Choose destination MongoDB collection and config fields.

Extract MongoDB query data to Percona collection - select collection

3. Set rows options.

Load data from Percona query to MongoDB collection - preview

4. Export Percona query results to MongoDB collection.

Transfer data from Percona query to MongoDB collection - export

Click "View", See MongoDB collection data.

Export data from Percona to MongoDB - view collection



1 Table to 1 Collection

Click "Convert From Table" at task dialog.

Import data from Percona table to MongoDB collection - Task Window

then show the wizard.

1. Choose source Percona table.

Convert data from Percona table to MongoDB collection - open table

2. Choose destination MongoDB collection and config fields.

Extract Percona table data to MongoDB collection - select collection

3. Set rows options.

Load data from Percona table to MongoDB collection - summary

4. Copy Percona table data to MongoDB collection.

Transfer data from Percona table to MongoDB collection - Transfer

Click "View", See MongoDB collection data.

Export data from Percona table to MongoDB collection - view collection



N Tables to 1 Collection

Click "Convert Similar Tables" at task dialog.

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

then show the wizard.

1. Select source Percona tables.

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

2. Choose a destination MongoDB collection and config fields.

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

3. Set rows options.

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

4. Copy data from Percona to MongoDB.

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

Click "View", See MongoDB collection data.

Export data from multiple MongoDB collections to Percona table - view collection



N Tables to N Collections

Click "Convert All Tables" at task dialog.

Import data from Percona tables to MongoDB collections - Task Window

then show the wizard.

1. Select source tables.

Convert data from Percona tables to MongoDB collections - open collection

2. Target collections, choice "Import Type".

Extract Percona tables data to MongoDB collections - select table

3. Map Percona tables to MongoDB collections.

Import data from relational databases Tables To MongoDB Collections - select tables

4. Summary.

Load data from Percona tables to MongoDB collections - preview

5. Batch copy Percona data to MongoDB.

batch copy data from Percona tables to MongoDB collections - batch copy

Click "View", See MongoDB collection data.

Export data from MongoDB collections to Percona table - view collection

Schedule task for "Percona to MongoDB"

After coping Percona data to MongoDB in Command Line, then you can schedule and automate "Percona to MongoDB" conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for "Percona to MongoDB" conversion.
  2. Set scheduled task: On Linux/macOS, use Crontab. On Windows, use scheduled task.

FAQ

How long does it take to copy Percona data to MongoDB?


Is it safe to copy Percona data to MongoDB using DBToMongo?



Can I copy Percona data to MongoDB in command line?


Can I batch copy data from Percona tables to MongoDB collections?


Download Withdata DBToMongoDownload DBToMongo