The Ultimate Guide to High Availability with MariaDB

dbForge Schema Compare

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

Compare and synchronize differences in DDL of database objects.

dbForge Schema Compare performs schema comparison and synchronization, that supports MariaDB database servers as well as Percona and MySQL. The tool gives a comprehensive view of all differences between database schemas, generates a clear and accurate SQL synchronization script that can be used to update a database schema. Comparison tasks for 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 of 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 of object types for comparison

3. Comparison Results Analysis

  • DDL differences in the text comparer with multicolor highlights based on the difference type
  • Automatic object grouping by type
  • Management of object groups in the comparison document
  • Filtering of objects by name or difference type
  • Sorting of compared objects
  • Exclusion of objects from synchronization
  • Saving and loading of comparison settings

4. Data Comparison Results Export

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

5. Synchronization Features

  • Creation of 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 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 Automation of routine tasks using command line

8. SQL Execution and Data Management

  • Concurrent showing of query text and retrieved data
  • 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
  • Postponed sending of 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 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.