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.
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 Name | Version |
---|---|
DB2 LUW | 10.1, 10.5, 11.1 |
MySQL | 5.1, 5.5, 5.6, 5.7 |
Oracle | 10g, 11g, 12c |
PostgreSQL | 9.0, 9.1, 9.2, 9.3, 9.4, 9.5 ,9.6 |
SQL Server | 2005, 2008, 2012, 2014, 2016 |
Sybase ASE | 15, 16 |
Sybase IQ | 15.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.
SELECT
and EXECUTE
privileges on the schema objects you want to compare.