The Schema Compare Tool identifies differences in DDL between database objects in two different schemas. It supports comparisons across the same or different DBMS vendors. The Schema Synchronization Tool compares and synchronizes the DDL of the selected target database objects to match that of the source database objects. It supports synchronization between the same DBMS vendor only, but the source and the target may be different DB versions. For example, synchronization between Oracle 12g and Oracle 10g is supported, but synchronization between Oracle 12g and SQL Server 2016 is not supported.

You can use either of the tools for comparing schemas. However, the schema synchronization tool always extracts dependencies of the selected schema objects which results in additional queries being executed. Therefore, if your requirement is to only compare schemas and not synchronize then use the schema compare tool instead of the schema synchronization tool.

Databases Support

Schema Compare supports all natively supported databases of Aqua Data Studio whereas Schema Synchronization supports many of the most commonly used native databases. The following table lists the databases and their versions supported by Schema Synchronization.

Database NameVersion
DB2 LUW10.1, 10.5, 11.1
MySQL5.1, 5.5, 5.6, 5.7
Oracle10g, 11g, 12c
PostgreSQL9.0, 9.1, 9.2, 9.3, 9.4, 9.5 ,9.6
SQL Server2005, 2008, 2012, 2014, 2016
Sybase ASE15, 16
Sybase IQ15.1, 15.2, 15.4, 16.0

Privileges Required for Deploying Schema Compare Scripts

To deploy Schema Compare scripts for Oracle, we recommend you have DBA privileges. In the Edit Server Properties for Oracle, you must log in with an account with DBA privileges, and then in the Advanced tab, select Use DBA Views check box.

For comparing schemas, you must have SELECT and EXECUTE privileges on the schema objects you want to compare.
  • No labels