Compare and Sync MySQL and MariaDB Data

Data Comparison Setup

The Data Comparison functionality covers a wide range of options that allows you to quickly identify differences and make the data comparison process easier and faster.

• Fine-tune comparison in the Data Comparison Wizard
• Support for custom comparison keys
• Various options for automatic mapping
• Exclude certain record types from comparison
• Compare user custom queries
• Filter data comparison by selecting objects you want to compare

Supported Data

With dbForge Data Compare for MySQL, the following data can be used as Target and Source for data comparison and synchronization.

• Tables
• Views
• BLOB data
• User custom queries
• Compare and synchronize databases on different MySQL server versions

Broad Compatibility Options

dbForge Data Compare for MySQL supports the most popular cloud databases, storage and search engines compatible with MySQL that you can use to perform data comparison and synchronization tasks.

• All popular MySQL and MariaDB server versions
• MySQL and MariaDB, which are set up on Windows, Linux, FreeBSD, Fedora OS
• Cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud
• Security connections: Secure Sockets Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona

More on Connectivity and Compatibility

Manage Comparison Results

The tool provides lots of options to analyse data comparison results that include:

• Group records by type (different, equal, etc.) in every object being compared
• Change the direction of synchronization in one click
• Filter comparison results
• Edit values of default comparison options
• Find tables by name
• Exclude objects (or their records) from synchronization with one click
• Save and load comparison settings
• View warnings on possible data losses or errors during synchronization
• Get notifications on data overflow, roundings, etc.

Export Comparison Results

Easily share comparison results with your colleagues and store data comparison differences in a comparison results file:

• Generate data comparison reports in Excel, HTML, and CSV formats
• Include actual data into a report
• Report on selected objects only
• Simple work with differences in Hide Unmodified Columns, Find, Visible Columns
• Filter results in comparison report by including objects with differences and objects selected for synchronization

Synchronization Features

Discover a rich set of synchronization features available in the dbForge Data Compare for MySQL tool that will help you easily achieve data consistency when comparing and synchronizing source and target MySQL databases:

• Creating accurate synchronization scripts
• Reviewing warnings on possible issues prior to synchronization
• Performing asynchronous data synchronization
• Creating custom scripts o be executed after and/or before the data synchronization process
• Displaying warnings that may cause possible issues and affect synchronization

Routine Task Automation

dbForge Data Compare for MySQL saves your time on automating and scheduling synchronization tasks.

• Use the command line interface to automate routine synchronizations
• Create a command line execution file to run routine data comparison and synchronization tasks in a single click
• Schedule routines execution with Windows Scheduler
• Create and run PowerShell automation scripts
• Save comparison and synchronization results in a .bat command-line execution file
• Enable PowerShell to ensure the PowerShell compatibility

Script Folder Comparison

In addition to comparing data in two databases, you can compare data from a database with the data stored locally in a script folder.

With the help of the new Data Comparison wizard, you can choose any database from any established connection and any script folder located on your machine.

After you specify the necessary additional options and mapping settings, the results of the data comparison process will be shown in a convenient data result grid.