dbForge Schema Compare for MySQL

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

dbForge Schema Compare for MySQL is a tool for performing schema comparison and synchronization, that supports MariaDB database servers as well as Percona servers, so it is easy to manage MariaDB users and their privileges. The tool gives a comprehensive view of all differences between MySQL database schemas, generates a clear and accurate SQL synchronization script that can be used to update a database schema. Comparison tasks for MySQL schemas can be scheduled using the command line interface.

Key features:

1. Supported Schema Objects

  • Tables
  • Views
  • Procedures
  • Functions
  • Triggers
  • Events
  • UDFs

2. Database Structure Comparison Setup

  • Fine-tuning comparison with Schema Comparison Wizard
  • Comparison options to ignore certain event options
  • Comparison options to ignore certain table options, DEFINER and SQL SECURITY expressions, default values for columns
  • Filtering object types for comparison

3. Comparison Results Analysis

  • DDL differences in the text comparer with multicolor highlights based on the difference type
  • Automatically group objects by their type
  • 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

4. Data Comparison Results Export

  • Generate data comparison report in Excel and HTML formats
  • Report on selected objects only

5. Synchronization Features

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

6. Database Backup and Restore

  • Comprehensive MySQL backup wizard
  • Database Restore Wizards
  • Schema- or data-only backups in addition to full backups
  • Backup projects for saving settings for future use
  • Command line interface for backup scheduling
  • Command-line interface for database restore

7. Tasks Automation Automate routine tasks using command line for schema comparison and synchronization

8. SQL Execution and Data Management

  • Show query text and retrieved data concurrently
  • Execution of SQL scripts and queries
  • Data editor with in-place filtering, grouping, and sorting options
  • Paginated data access for large result sets
  • Graphical card view for data editor
  • Large objects (LOB) viewer
  • Postpone sending data updates to the server (cached updates mode)
  • Code completion
  • SQL code formatter

9. 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
  • Restoring document tabs from the last session
  • Switching between wizard window and primary window

Learn more about dbForge Schema Compare for MySQL at the product page.


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.