Schema Compare for Oracle - 2.0
Viewing the SQL differences - Schema Compare for Oracle
When you are reviewing the comparison results, a side-by-side listing of differences in the creation SQL script for an object is displayed in the lower (SQL Differences) pane. To display the SQL Differences pane, click an object in the upper (Results) pane.
You can adjust the height of the SQL Differences pane by dragging it up or down, or by using the 
buttons to move the pane to a pre-set height.
Click 
to open the SQL Differences pane in a separate window. If you are working with multiple monitors, it can be useful to move this window to another monitor. Click again to re-dock the window.
If you close the SQL differences pane, click an object in the Results pane to display it again.
Viewing differences
Lines that contain differences are displayed with a shaded background; text within a line that is different is displayed with a darker shaded background.
The central column shows the type of difference:
|
there are differences in the group of SQL statements |
|
this line of SQL will be added if you synchronize this object (the direction of the arrow indicates the database that will be updated) |
|
this line of SQL will be removed if you synchronize this object |
There is no icon if the two lines are identical.
Use 
Next and 
Previous to go to lines that contain a difference. Alternatively, use Alt + Up Arrow and Alt + Down Arrow.
The Line Differences bar
The Line Differences bar displays the selected line of the SQL creation script in both data sources one on top of the other. This is especially useful when the lines are too long to view all the text.
To display the Line Differences bar, click 
and then click Line Differences.
Scroll bar
Colored blocks in the left scroll bar indicate the location in the script of lines that are different.
a line of SQL that exists only in the object script on the left
a line of SQL that exists only in the object script on the right
a line of SQL that exists in both object scripts, but is different
Searching and copying the creation script
To search the SQL statements, right-click in the relevant box, and click Find.
To repeat a search in the other data source, click either Find in target or Find in source.
The search is not case-sensitive.
See also |
Was this article helpful?
Using Schema Compare for OracleSchema Compare for Oracle
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
Schema Compare for Oracle
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
