Page History
...
| Info |
|---|
| 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 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.
| Info |
|---|
For comparing schemas, you must have SELECT and EXECUTE privileges on the schema objects you want to compare. |