issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

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

What can be compared and synchronized?

  • Tables
  • Views
  • BLOB data
  • Database comparison and synchronization on different MySQL server versions

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

Synchronization features

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

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

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

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