Contents

Requirements

MySQL Compatibility:

• Support for MySQL versions 5.5-8.3
• Support for MariaDB versions 5.5-11.4
• Support for Percona versions 5.5-8.1
• Secure connections via SSL/SSH
• Working with MySQL on Amazon RDS and on Amazon Aurora
• Azure MySQL
• Google Cloud Platform
• Alibaba Cloud
• Tencent Cloud
• Kamatera Performance Cloud
• Galera Cluster
• Sphinx Search Engine
• Oracle MySQL Database Service
• Work with MySQL embedded server
• HTTP connections via PHP tunnel
• Support for UTF-8 databases
• Direct access to MySQL server without client libraries
• Support for Windows authentication when creating connection to MySQL server
• MySQL pluggable authentication and Windows authentication on connecting to MySQL server (PAM)
• Percona PAM Authentication for MySQL
• MySQL 9.0 Connectivity Support

Services Compatibility

• StrongDM

System Requirements

• Microsoft Windows 7/8/8.1/10/11
• Windows Server 2008/2012/2016/2019/2022
• .NET Framework 4.7.2 or higher installed. You can download .NET Framework here.

Note

.NET Framework is pre-installed in Microsoft Windows 7/8/8.1/10/11.

• Linux
  • Ubuntu
  • Debian
  • Fedora
  • Red Hat Enterprise Linux (RHEL)
• macOS
  • Monterey version 12.00
  • Big Sur version 11.00
  • Catalina version 10.15
  • Mojave version 10.14
  • High Sierra version 10.13

Note

CodeWeavers CrossOver must be pre-installed in order to work with Linux and macOS. You can download it at CodeWeavers.

To check a list of macOS and Linux versions that are compatible with CrossOver, see CrossOver system requirements.

Permissions required to use Data Compare

dbForge Data Compare can compare and synchronize data of a SQL Server database. To perform this effectively, a user needs access to the schema and the data objects of a database and may require additional privileges depending on the options of data synchronization.

MySQL 5.5 - 8.3.0 and MariaDB 5.5-11.3

Task	Permissions
Comparing data	GRANT SELECT, SHOW VIEW ON database_name.* TO ‘user_name’@’%’;
Synchronizing data	GRANT INSERT, UPDATE, DELETE ON database_name.* TO ‘‘user_name’@’%’;
Synchronizing data with special options of sync: archive engine to InnoDB, disable foreign keys, disable primary keys and indexes, disable check constraints, disable DML triggers	GRANT ALTER, DROP, CREATE ON database_name.* TO ‘‘user_name’@’%’;

MySQL 5.5 - 8.3

Task	Permissions
Comparing data	GRANT SELECT ON database_name.* TO ‘user_name’@’%’;
Synchronizing data	GRANT INSERT, UPDATE, DELETE ON database_name.* TO ‘‘user_name’@’%’;

MariaDB 5.5-11.4

Task	Permissions
Comparing data	GRANT SELECT ON database_name.* TO ‘user_name’@’%’;
Synchronizing data	GRANT INSERT, UPDATE, DELETE ON database_name.* TO ‘‘user_name’@’%’;

Note

In order to compare data with the tool you need to have at least one of the following permissions:

SELECT ON <database_name>.<table_name>
SELECT ON <database_name>.<view_name>

Permissions issues

In case you don’t have the right permissions:

• Some objects may be missing from the comparison results.
• The synchronization itself and synchronization scripts may fail or have unexpected results.
• The “Archive Engine To InnoDB”, “Disable foreign keys”, “Disable primary keys and indexes”, “Disable check constraints”, “Disable DML triggers” options require access to Data Definition Language modification, so it may be necessary to use GRANT ALTER, DROP, CREATE ON <database_name>.<table_name> to allow the synchronization to succeed if any of the mentioned options is configured.

Want to Find out More?

• Previous
• Next