dbForge Data Compare for MySQL Features

View the whole list of dbForge Data Compare for MySQL. For a list of new features, see What's New in 5.0

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

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