Compare and Sync MySQL Database Schemas

Broad Compatibility

dbForge Schema Compare for MySQL is compatible with:

• MySQL server versions 5.5-8.3
• MariaDB server versions up to 11.4
• All MySQL and MariaDB instances set up on Windows, Linux, FreeBSD, or 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

Supported Schema Objects

With dbForge Schema Compare for MySQL, the following objects can be compared and synchronized in source and target databases:

• Tables
• Views
• Procedures
• Functions
• Triggers
• Events
• Packages (MariaDB)
• Sequences (MariaDB)

Database Structure Comparison Setup

• Fine-tune the comparison process with the Schema Comparison Wizard
• Ignore specific event options during comparison
• Swap the Target and Source databases in the Schema Comparison wizard
• Ignore specific table options during comparison; DEFINER and SQL SECURITY expressions; default values for columns
• Filter object types for comparison
• Ignore the autoincrement table option
• Ignore the END clause

Comparison Results Analysis

• Clear and comprehensive display of schema differences in the grid
• DDL differences in the text comparator with multicolor highlights based on the difference type
• Automatically group objects by their type
• Manage groups of objects in the comparison document
• Filter objects by name or difference type
• Sort the compared objects
• Exclude objects from synchronization
• Save and load comparison settings

Comparison Results Export

Schema Compare allows easily generating a report with the comparison results in the following file formats:

• HTML
• Excel XML
• XML for Excel

In addition, a comparison report can include specifically-selected objects such as:

• Objects with differences
• Objects selected for synchronization
• Identical objects

that may be grouped by status or object type.

Schema Sync

The schema synchronization functionality is featured with the following options:

• Generate clear and accurate synchronization scripts to update database schemas
• Synchronization script preview for any specific schema object
• Options to customize the synchronization script output
• Warnings on possible data losses or errors during synchronization
• Asynchronous structure synchronization

MySQL Backup and Restore

• Comprehensive MySQL backup wizard
• Database Restore Wizards
• Schema- or data-only backups in addition to full backups
• Support for large databases (over 2 Gb)
• Backup projects to save settings for future use
• Zip compression for backup files
• Command line interface for backup scheduling
• Command line interface for database restoration
• Error and status logging

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

Routine Tasks Automation

Automating the routine tasks can help increase the efficiency of the comparison and synchronization process with the following capabilities:

• Launch schema comparison and synchronization through the command line
• Create command line execution files to run routine schema comparison and synchronization tasks in a single click
• Automate the synchronization process by using the Windows Scheduler
• Create and run PowerShell automation scripts