.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.
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.
dbForge Schema Compare can compare and synchronize schemas of a SQL Server database. To perform this effectively, the 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.
Task | Permissions |
---|---|
Comparing data | GRANT SELECT, SHOW VIEW ON database_name.* TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.user TO ‘user_name’@’%’ GRANT SELECT ON TABLE mysql.db TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.tables_priv TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.columns_priv TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.procs_priv TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.proxies_priv TO ‘user_name’@’%’; |
If you do not need privileges on database objects, then you should enable Ignore permissions and have only the GRANT SELECT, SHOW VIEW ON `autotest_db_describe`.* TO 'user_name'@'%'
permission.
Task | Permissions |
---|---|
Comparing data | GRANT SELECT ON TABLE mysql.role_edges TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.global_grants TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.default_roles TO ‘user_name’@’%’; |
Task | Permissions |
---|---|
Comparing data | GRANT SELECT ON TABLE mysql.roles_mapping TO ‘user_name’@’%’; GRANT SELECT ON TABLE mysql.global_priv TO ‘user_name’@’%’; |