Pair collections or tables across databases or connections, then compare their rows, their structure, or both. See which pairs differ at a glance, drill into field-level differences, and preview every change before you sync, in either direction.
The Structure tab lists what differs for each pair: columns, primary key, indexes, foreign keys, CHECK constraints and triggers for SQL tables, and indexes, validator and options for MongoDB collections. Tables or collections that exist on only one side are listed too. Each item is coloured by what Sync would do, and a live script preview shows the exact statements it would run. Tick what to apply and make the target match, or the source.
Each pair shows its last result, such as "12 modified · 3 missing" or identical, and differing pairs are listed first. Pair two whole databases in one step with Match whole database, or right-click a database or schema and choose Compare Structure with… to start straight from the sidebar.
Expand a modified document or row to see the exact field paths, status badges such as Identical and Modified, and source and target values side by side. Spot schema drift and data inconsistencies with precision.
Preview a sync before you run it: how many inserts, updates and deletes, and each operation by collection or table and key. SQL syncs are all-or-nothing, so a failed sync never leaves a table half updated, and a stopped sync picks up where it left off instead of starting over.
Data Compare works across all your saved connections. Compare production with staging, or any two databases in your connection list, MongoDB or SQL.
Copy whole databases, tables or collections between environments with Data Transfer, then compare them to confirm nothing was lost. Schedule tasks to keep copies fresh.
Check out the documentation to explore all the details about Data Compare and discover more VisuaLeaf features.
Read the DocumentationGet started free with our Community Edition. Includes a 14-day trial of Pro features.