Copy data from PostgreSQL query to MongoDB collection without programming

by

Posted on by

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

Using DBToMongo, a PostgreSQL to MongoDB converter for Windows, MacOS, and Linux, you can transfer data from PostgreSQL query to MongoDB collection easily 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 DBToMongo Download DBToMongo

Copy data from PostgreSQL query results To MongoDB collection

Login to PostgreSQL.

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

Login to MongoDB.

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

Click “Convert From Query” at task dialog.

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

then show the wizard.

1. Enter source PostgreSQL query.

Convert data from PostgreSQL query to MongoDB collection - enter query

2. Choose destination MongoDB collection and config fields.

Extract MongoDB query data to PostgreSQL collection - select collection

3. Summary.

Load data from PostgreSQL query to MongoDB collection - preview

4. Export PostgreSQL query results to MongoDB collection.

Transfer data from PostgreSQL query to MongoDB collection - export

Click “View”, See MongoDB collection data.

Export data from PostgreSQL to MongoDB - view collection

Copy data from PostgreSQL query results to MongoDB in command line

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

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

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task for Windows.

FAQ

More about DBToMongo – PostgreSQL to MongoDB Converter