dbForge Data Compare for MySQL

dbForge Data Compare for MySQL: Find the Rows That Differ Between Two Databases and Sync Them

dbForge Data Compare for MySQL is Devart's Windows tool for comparing the table data of two MySQL or MariaDB databases, showing exactly which rows differ, and writing the INSERT, UPDATE and DELETE script that makes the target match. It costs $84.95 a year or $169.95 for a perpetual license, and it's for developers and DBAs who move lookup data between environments or need to repair rows that went missing.

Someone ran an UPDATE on production's price table without a WHERE clause, and last night's backup is sitting on a test server. Data Compare puts the two side by side, shows the changed rows, and gives you a script for just those rows instead of a full restore.

Download Free TrialBuy Now

Overview

Data Compare for MySQL does one job well. You pick a source and a target, it maps tables and columns, and the results grid groups every table as different, only in the source, only in the target or identical, with row counts for each. Select a table and you see its rows side by side, with the changed values highlighted. Then the Data Synchronization Wizard writes the script, which you can open in the built-in SQL editor, save, or run directly.

Devart updates it alongside its MySQL Studio. The September 2026 release added support for MariaDB 13 and the newest MySQL server versions, the October build added new MariaDB syntax and fixed an "Unknown table 'TABLESPACES'" error, and the November build fixed an out-of-memory error on large Excel reports.

Features

Row-by-row results you can filter and export

dbForge Data Compare for MySQL shows each table's rows in tabs (all, only in source, different, only in target, identical), lets you search for specific records, filter tables with different or identical rows, and include or exclude objects. Reports go out as XLS, HTML or CSV, optionally with the number of differences per column and the actual records.

Comparing sakila on localhost with a remote copy: five tables differ, 66 changed rows in city shown side by side, and the report dialog set to Excel.

A synchronization script you can read first

dbForge Data Compare for MySQL generates the sync script automatically, taking care of foreign key constraints around the changes, warns you about potential issues, and lets you add your own scripts before and after. You choose whether to open the script in the editor, save it with a timestamp, or execute it against the target and refresh the comparison.

The wizard's Output page and the generated script opened in the editor, starting by dropping foreign keys on city, film and staff.

Command-line automation

dbForge Data Compare for MySQL saves any comparison as a .bat file with a settings dialog that builds and validates the command line, so you can run it from Windows Task Scheduler or a PowerShell script. The console output summarizes identical, different, source-only and target-only records.

A command-line comparison of sakila between MySQL 9.4.0 and 9.1.0 (471 identical, 165 different records), beside the dialog that builds the .bat file.

Benefits

• Targeted repairs. Restore the rows that went wrong, down to a single row, without overwriting good changes made since a backup.
• Consistent reference data. Push lookup tables (countries, price lists, settings) from development to staging and production with a script you've reviewed.
• Proof of what changed. A report shows exactly which records differ between two environments.
• Cheap for what it does. At $84.95 a year it costs half of the Studio's Professional edition if data sync is all you need.

Real-World Uses

• Recovering from a bad UPDATE: compare the damaged table with a restored copy and sync only the affected rows back.
• Releasing configuration data: after a schema deployment, sync the new rows in lookup tables from staging to production.
• Checking a migration: after moving a database to Amazon RDS or a new MySQL version, confirm every table's rows match the old server.
• Nightly consistency check: schedule a comparison between primary and reporting databases and save an HTML report.

Who It's For, and Who Should Skip It

Buy it if you're a developer or DBA who regularly compares or syncs MySQL or MariaDB data between environments and doesn't need a full IDE.

Skip it if you also need schema compare and a SQL editor (get dbForge Studio for MySQL Professional instead); if your syncing is continuous rather than on demand, where replication is the right tool; or if you're on a Mac and don't want CrossOver.

Usage Guide

1. Download and install the Compare Bundle for MySQL from Devart's download page (sign in with a free Devart account) and choose Data Compare.
2. Start a New Data Comparison. Pick the source and target (database, scripts folder or custom query) and their connections.
3. Check the mapping. Review which tables and columns are paired.
4. Review results. Open each different table and look at the changed rows; exclude anything you don't want to touch.
5. Synchronize. Run the Data Synchronization Wizard, read the warnings, and open, save or execute the script.
6. Automate. Click Save Command Line to turn the comparison into a scheduled job.

Where It Falls Short

What Users Say

There are almost no independent reviews of the stand-alone Data Compare for MySQL: SoftwareSuggest has none. Devart quotes three users on its product page, one of them from G2, so read these as the vendor's picks.

The evidence is thin but consistent: people who need MySQL data sync and try several tools tend to pick Devart's. Test it on a copy of your own largest tables during the 30-day trial.

Comparisons

Editions and Pricing

Data Compare for MySQL has a single, full-featured edition. The order page opens on the 1-year subscription; the perpetual license, 2- or 3-year support terms and priority support are options there.

Devart takes 5% off for 5 to 9 licenses, 10% for 10 to 19 and 15% for 20 or more.

FAQs

Does dbForge Data Compare for MySQL work with MariaDB?

Yes. dbForge Data Compare for MySQL supports MariaDB 5.5 to 13, Percona Server and Galera Cluster as well as MySQL.

Can it compare databases on different MySQL versions?

Yes. dbForge Data Compare for MySQL compares and synchronizes databases running on different server versions, which is useful when checking a migration.

Can I compare only part of a table?

Yes. dbForge Data Compare for MySQL can compare the results of custom queries instead of whole tables, and you can exclude tables and filter results.

Does it work with Amazon RDS?

Yes. dbForge Data Compare for MySQL connects to Amazon RDS and Aurora (including IAM authentication and RDS Proxy), Azure Database for MySQL, Google Cloud, Alibaba Cloud and other MySQL cloud services.

What happens when my subscription ends?

A dbForge Data Compare for MySQL subscription becomes inaccessible when it ends, until you renew. The perpetual license keeps working; renewing it only brings updates and support.

Can I get a refund?

Yes. Devart refunds dbForge Data Compare for MySQL within 30 days of purchase if you're not satisfied.

System Requirements

• Windows 7, 8, 8.1, 10 or 11, or Windows Server 2008, 2012, 2016, 2019, 2022 or 2025
• .NET Framework 4.7.2 or later
• macOS or Linux (Ubuntu, Debian, Fedora, RHEL): CodeWeavers CrossOver
• MySQL 5.5 and later, MariaDB 5.5 to 13, Percona 5.5 to 8.4
• About 105 MB for the installer download