This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-13. For the latest, interactive version please visit https://mariadb.com/kb/.

dbForge Data Compare

dbForge Data Compare helps compare and synchronize data in MariaDB, MySQL, and Percona databases and scripts folders. With this powerful GIU tool, you can easily find differences between your data, as it helps analyze comparison results, creates a synchronization script, and applies changes. Plus, MariaDB data can be compared with command-line support.

dbForge Data Compare Tool Features:

1. 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

synchronization-features

2. MySQL & MariaDB Task Automation

  • Automate routine synchronizations with a command-line interface
  • Plan your routine execution with Windows Scheduler
  • Support for PowerShell compatibility

automate-routine-task

3. 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

script-folder-comparison

4. Rich configurations for data comparison

  • Enjoy various options for automatic mapping
  • Compare customized queries
  • Compare custom keys

data-comparsion-setup

5. Supported Data

  • Tables
  • Temporal tables
  • Views
  • BLOB data
  • Compare databases and sync different MariaDB versions

6. Broad Compatibility Options

  • All popular MariaDB server versions
  • MariaDB set up 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

7. 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

8. 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

VersionIntroduced
dbForge Data Compare 10.1Support 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.0Support for MariaDB 11.4, Added support for temporal tables in MariaDB
dbForge Data Compare 5.9Support for MariaDB 11.3
dbForge Data Compare 5.8Support for MariaDB 10.9, Support for MariaDB 10.10
dbForge Data Compare 5.7Connectivity support for MariaDB 10.5 is added
dbForge Data Compare 5.5Support for MariaDB 10.4
dbForge Data Compare 5.4Support for MariaDB 10.3
dbForge Data Compare 5.3Support for MariaDB 10.2, Support for MariaDB 10.1
dbForge Data Compare 4.1MariaDB 10.0, MariaDB 5.5
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.