Broad Compatibility Options

dbForge Schema Compare for MySQL is compatible with:

  • All MySQL server versions
  • All MariaDB server versions
  • 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

dbForge Studio for MySQL Compatibility

Supported Schema Objects

  • Tables
  • Views
  • Procedures
  • Functions
  • Triggers
  • Events
  • UDFs
Supported Schema Objects

Database Structure Comparison Setup

  • Fine-tuning comparison with Schema Comparison Wizard
  • Comparison options to ignore some event options
  • Swap button to swap Target and Source databases on Schema Comparison wizard
  • Comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns
  • Filtering object types for comparison
  • Ignore autoincrement table option
  • Ignoring ENDS clause
Schema Objects Support

How can I analyze comparison results?

  • Clear display of schema differences in the grid
  • DDL differences in the text comparer with multicolor highlights based on the difference type
  • Group objects by their type automatically
  • Manage groups of objects in the comparison document
  • Filter objects by name or difference type
  • Sort compared objects
  • Exclude objects from synchronization
  • Save and load comparison settings
How can I analyze comparison results?

How can I export data comparison results?

  • Generate data comparison report in the HTML, Excel XML, and XML for Excel file formats
  • Report on selected objects only
How can I export data comparison results?

Synchronization Features

  • Create accurate synchronization scripts
  • Synchronization script preview for any separate schema object
  • Options to customize the synchronization script output
  • Warnings on possible data losses or errors during synchronization
  • Asynchronous structure synchronization
Synchronization Features

Database Backup and Restore

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

How can I automate my routine tasks?

  • Command line launch for schema comparison and synchronization
  • Creation of command line execution file to run routine schema comparison and synchronization tasks in a single click
How can I automate my routine tasks?

SQL Execution and Data Management

  • Show query text and retrieved data at the same time
  • Execution of SQL scripts and queries
  • Data editor with in-place filtering, grouping, and sorting options
  • Paginal data access for large result sets
  • Graphical card view for data editor
  • Large objects (LOB) viewer
  • Text search in data editor
  • Data printing
  • Postpone sending data updates to the server (Cached updates mode)
  • Code completion
  • SQL code formatter
  • Formatting code through the command line
  • Query execution pane
SQL Execution and Data Management

Clear User Interface

  • Wide variety of UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Tabbed groups for documents
  • Toolbars customization
  • Windows connection coloring
  • Restoring document tabs from the last session
  • Switching between wizard window and primary window
Clear User Interface