Broad Compatibility Options

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

Data Comparison Setup

  • Fine-tuning comparison in Data Comparison Wizard
  • Custom comparison keys support
  • Various options for automatic mapping
  • Ability to exclude some record types during comparison
  • Comparison of user custom queries
Data Comparison Setup

What can be compared and synchronized?

  • Tables
  • Views
  • BLOB data
  • Database comparison and synchronization on different MySQL server versions
What can be compared and synchronized?

How can I analyze comparison results?

  • Group records automatically in every compared object by type (different, equal, etc)
  • Change synchronization direction 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
How can I analyze comparison results?

How can I export data comparison results?

  • Generate data comparison report in Excel, HTML, and CSV formats
  • Include actual data into report
  • Report on selected objects only
  • Easy working with differences with Hide Unmodified Columns, Find, Visible Columns, and navigation buttons
How can I export data comparison results?

Synchronization features

  • Creating accurate synchronization scripts
  • Warnings on possible problems prior to synchronization
  • Asynchronous data synchronization
Synchronization features

How can I automate my routine tasks?

  • Use command line interface for automatic routine synchronizations
  • Create a command line execution file to run routine data comparison and synchronization tasks in a single click
How can I automate my routine tasks?

SQL Execution and Data Management

  • New SQL document view layout to 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) editor
  • Text search in data editor
  • Data printing
  • Ability to postpone sending of 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