Compare & Sync

Compare and sync entire MongoDB databases

Compare & Sync

Do you ever need to download the production DB to your localhost for development purposes? Or just sync changes from one DB to another?

Well, all this can be done using Mingo’s Compare & Sync tool. You don’t need to write scripts or use the terminal mongodump / mongorestore functions, anymore.

Compare and Sync

With Mingo’s Compare & Sync tool you can:

  • compare collections in two different databases (source and destination, databases may be on same or different servers)
  • select the collections to compare
  • analyze each document and tell if it has been added, removed or updated in source collections
  • synchronize the changes into destination collections
The comparison happens in 3 steps:
  1. Get meta information (list of collections and number of documents in each)
  2. Comparison of actual documents in both source and destination collections
  3. Synchronizing document changes into destination collections (if requested)
Under the hood

Document comparison happens on the corresponding servers directly. The comparison creates a hash for each document and sends them back to Mingo. Mingo compares the hashes and tells you how many docs have been added, removed and updated.

Synchronizing

Once the comparison has been finished, Mingo lets you choose the collections you want to synchronize. Before sync, you are prompted to choose which documents to sync (added, updated, removed).

Saving comparison setup for future use

Once the source db, destination db and the collections to compare have been selected, you can save this comparison setup and reuse it in future for faster synchronizing.

* The actual hashing may put high CPU load on the servers in case of large collections, so Mingo skips collections with more than 100k documents. Running Compare & Sync requires a local mongo instance.

Try Mingo

intuitive • fast • reliable

More articles

Hidden features

7 hidden features that make Mingo so addictive

Read more
Aggregation

Aggregation: simplified and visualized

Read more
Compare & Sync

Compare and sync entire MongoDB databases

Read more
Indexes

Creating indexes with a breeze

Read more
Deep links

Deep linking from other apps or websites

Read more
Analyzing

Analyzing data consistency

Read more
Dates

Querying by dates in - the human way

Read more