dbForge Data Compare

dbForge Data Compare 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.

MySQL & MariaDB Task Automation

• Automate routine synchronizations with a command line interface.

• Plan routine execution with Windows Scheduler.

• Support for PowerShell compatibility.

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.

Configurations for Data Comparison

• Various options for automatic mapping.

• Compare customized queries.

• Compare custom keys.

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.

Documentation

_{This page is licensed: CC BY-SA / Gnu FDL}