# dbForge Data Compare

[dbForge Data Compare](https://www.devart.com/dbforge/mysql/datacompare/) helps compare and synchronize data in MariaDB, MySQL, and Percona databases and scripts folders. You can find differences between your data, as it helps analyze comparison results, creates a synchronization script, and applies changes. Additionally, MariaDB data can be compared with command-line support.

Features are described in the following.

## Database Synchronization Features

* Create accurate synchronization scripts.
* Synchronize asynchronous data.
* Create custom scripts with execution before/after the process of data synchronization.
* Get warning messages on errors during synchronization.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-8ba243eb05e52cd2c450a5762e27b88d50afc050%2Fsynchronization-features.png?alt=media)

## MySQL & MariaDB Task Automation

* Automate routine synchronizations with a command line interface.
* Plan routine execution with Windows Scheduler.
* Support for PowerShell compatibility.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-02c73bcf09ba261e01134dfd5c600c80a62322cf%2Fautomate-routine-task.png?alt=media)

## Script for Folder Data Comparison

* Compare data from your database with the data placed in the script folder locally.
* Choose any database, connection, or script folder with the new Data Comparison Wizard.
* See the data comparison results in a data result grid.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-d24bb20b17cffac8bf9bf4ba8e31b1add928570a%2Fscript-folder-comparison.png?alt=media)

## Configurations for Data Comparison

* Various options for automatic mapping.
* Compare customized queries.
* Compare custom keys.

![](https://2988006611-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSsmexDFPv2xG2OTyO5yV%2Fuploads%2Fgit-blob-0700a7817e4e60dc5d78acdb73da5b24277f0c5a%2Fdata-comparsion-setup.png?alt=media)

## Supported Data

* Tables.
* Temporal tables.
* Views.
* `BLOB` data.
* Compare databases and sync different MariaDB versions.

## Compatibility Options

* All popular MariaDB server versions.
* MariaDB setup on Windows, Linux, FreeBSD, etc.
* Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud.
* Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona security connections.

## Manage Comparison Results

* Find tables by name.
* Filter the comparison process results.
* Enter the values of default comparison options.
* Group records by type in each compared object.

## Export Comparison Results

* Use only relevant data in your reports.
* Generate comparison reports in various formats.

Download a free 30-day trial of dbForge Data Compare [here](https://www.devart.com/dbforge/mysql/datacompare/download.html).

[Documentation](https://docs.devart.com/data-compare-for-mysql)

| Version                   | Introduced                                                                                                                                                             |
| ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| dbForge Data Compare 10.1 | Support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on AWS and enhanced cloud compatibility features, new automation capabilities. |
| dbForge Data Compare 10.0 | Support for MariaDB 11.4, Added support for temporal tables in MariaDB.                                                                                                |
| dbForge Data Compare 5.9  | Support for MariaDB 11.3.                                                                                                                                              |
| dbForge Data Compare 5.8  | Support for MariaDB 10.9 and 10.10.                                                                                                                                    |
| dbForge Data Compare 5.7  | Connectivity support for MariaDB 10.5.                                                                                                                                 |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}