dbForge Data Compare

You are viewing an old version of this article. View the current version here.

Compare & synchronize data between databases.

dbForge Data Compare serves for data comparison and synchronization in MariaDB, MySQL, Percona databases. It gives clear view of differences between data, allows analyzing them, generates synchronization script, and applies changes at a glance. It also allows scheduling regular data comparisons using command line interface.

Key features:

1. Data Comparison Setup

  • Fine tuning of 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

2. Supported Database Objects

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

3. Comparison Results Analysis

  • 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

4. Data Comparison Results Export

  • 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

5. Synchronization Features

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

6. Tasks Automation Automate routine tasks using command line interface for data comparison and synchronization

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

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

Learn more about dbForge Data Compare at the product page

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.