The Schema Compare tool allows you to compare entire schemas or portions of schemas across two Server Explorer Oracle Database connections, between an Oracle Database Project Version 2 and an Oracle Database Connection, or between two Oracle Database Project Version 2 projects.

You can view the comparison results in a results window to see the differences. You can also generate a deployment script, a diff script, that can be used to upgrade the target database schema to match the source schema (for Oracle Database connection targets only). You can also tell Schema Compare to update the target directly without generating a script (for either Oracle Database connection or Oracle Database Project Version 2 target types).