dbForge Schema Compare

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

dbforge_schema_compare_for_mysqldbForge Schema Compare is an efficient solution that allows for the comparison of the MariaDB database structure. With this tool, you can easily find the differences in MariaDB database schemas.

Key features:

1. Schema Sync

Update MariaDB schemas by generating accurate synchronization scripts Preview sync scripts for any schema objects Customize the synchronization output with various options Get warnings on possible errors while synchronization Sync asynchronous structure

SynchronizationFeatures

2. MariaDB Backup and Restore

Enjoy the advantages of MariaDB backup and restore Wizards Have a full or partial backup Restore database and schedule backups with a command-line interface Support for databases over 2Gb

DatabaseBackup

3. Scripts Folder Comparison

Compare the data both in two different databases and the database data with the data placed locally Choose any connection and script folder stored locally with the new Data Comparison Wizard View the comparison process results in a data grid

script-folder-comparison

4. Routine Tasks Automation

Sync and compare schemas with command-line support Use the Windows Scheduler to automate the sync processes Run synchronization and schema comparison tasks with command-line execution files

HowcanIautomatemyroutinetasks

5. Broad Compatibility

MariaDB server versions 5.5-10.6 All MariaDB instances set up on Windows, Linux, FreeBSD, etc. Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud Security connections: Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona

broad-compatibility-new

6. Supported Schema Objects

Packages Sequences

SupportedSchemaObjects

7. Database Structure Comparison Configuration

Filter the types of objects before the comparison Dismiss particular table options while comparing Use the Schema Comparison Wizard for switching between the Target and Source databases

DatabaseStructureComparisonSetup

8. Comparison Results Analysis

Sort and filter the compared objects Get a clear view of schema diffs in the grid. Manage groups of compared objects

HowcanIanalyzecomparisonresults

9. Comparison Results Export

Generate comparison results reports in HTML, Excel XML, XML for Excel Include specifically selected objects in your comparison report

HowcanIexportdatacomparisonresults

Download a free 30-day trial of dbForge Schema Compare here.

Documentation

VersionIntroduced
dbForge Schema Compare 5.0MariaDB 10.5
dbForge Schema Compare 4.4MariaDB 10.4
dbForge Schema Compare 4.3MariaDB 10.3
dbForge Schema Compare 4.2MariaDB 10.2, MariaDB 10.1
dbForge Schema Compare 3.1MariaDB 10.0, MariaDB 5.5

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.