Moving data
Compare and Sync
Diff two collections field by field and sync the differences.
Data Compare & Sync finds the differences between two collections, on the same connection or on different ones, and syncs them.
Compare
- Open Compare from the command palette or a collection's context menu.
- Choose the source and target collections.
- Run the comparison. Documents are matched by
_id(or another key field you choose) and sorted into:- only in source;
- only in target;
- changed, with a field-level diff showing exactly what differs.
Export the differences to a file to share or review them.
Sync
- Preview the sync first. It's a dry run that shows what would be written.
- Choose what to sync. You can sync everything or pick individual documents.
- Choose a conflict policy for documents that exist on both sides: source wins, target wins or skip.
- Run the sync and confirm.
Sync writes to the target, so it's blocked when the target connection is read-only.
Keep collections in step
- Save a comparison as a scheduled task to check for drift regularly.
- For continuous replication, use a continuous sync task: it applies a collection's change stream to another collection, optionally masking fields on the way. See Tasks and the command line.
AI summary
With Allow AI on, the assistant can summarize a large comparison result in plain words.
Something unclear or out of date? Write to support@motionql.com.