Compare databases on different MySQL server versions

Last modified: July 4, 2024

When comparing databases on different MySQL server versions, keep in mind the following:

Compare databases between the MariaDB server, which uses the ARIA or CONNECT engines, and the MySQL 8.0 server

If you compare two databases, one on the MariaDB server with the ARIA or CONNECT engine and the other on the MySQL 8.0 server, the synchronization of databases may fail because MySQL 8.0 does not support the ARIA or CONNECT engines. dbForge Schema Compare will define the databases as inconsistent.

The following screenshot illustrates the comparison between the source company_dev database on the MariaDB server using the ARIA engine and the target company database on the MySQL 8.0 server.

Compare databases, one of which contains a system-versioned table

If you compare two databases, and the source database contains a system-versioned table, the synchronization of databases may fail, and the script for this table won’t be generated. dbForge Schema Compare will identify the table as inconsistent.

The following screenshot illustrates the comparison between the source company_dev database, which includes the system-versioned sale table on the MariaDB 10.3 server and the target company database on the MariaDB 10.0 server.