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
...
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. |