This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-13. For the latest, interactive version please visit https://mariadb.com/kb/.

dbForge Schema Compare for MariaDB & MySQL

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.

Schema Compare Tool Key features:

1.MariaDB & MySQL Schema Synchronization

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 database 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. Supported Schema Objects

Packages

Sequences

SupportedSchemaObjects

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

7. Comparison Results Analysis

Sort and filter the compared objects

Get a clear view of MariaDB and MySQL schema diffs in the grid.

Manage groups of compared objects

HowcanIanalyzecomparisonresults

8. Comparison Results Export

Generate comparison results reports in HTML, Excel XML, XML for Excel

Include specifically selected objects in your comparison report

HowcanIexportdatacomparisonresults

9. Broad Compatibility

MariaDB server versions 5.5-11.4

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

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

Documentation

VersionIntroduced
dbForge Schema Compare 10.1Support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on AWS and enhanced cloud compatibility features, new automation capabilities
dbForge Schema Compare 10.0MariaDB 11.4, Added support for temporal tables in MariaDB
dbForge Schema Compare 5.2MariaDB 11.3
dbForge Schema Compare 5.1MariaDB 10.9, MariaDB 10.10
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
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.