Page History

Application settings allow you to tweak the behavior of IDERA Schema Compare for Oracle Database. It can be accessed from the drop-down menu off of the top-left corner product icon or from the link at the bottom-left corner Application Settings link on the Workspace tab.

Application level settings are grouped into the General, UI Preferences, and Workspace tabs.following tabs:

General

• Default Connection Settings. Generally, there is no need to change the connection settings, however, in certain scenarios you might need to adjust those values. From the application settings window you can set the Connection Timeout, Query Timeout, Network Protocol, and Network Packet Size. Specifies the Connection timeout, Query timeout, Port number, and whether the connections are pooled. Under normal circumstances, you do not need to change any of these settings.
• Log folder. Specifies the location where logs are stored. The user running the application must have write access to that location.
• Workspace database. Specifies the path and the name of the workspace database file. You can change this field by clicking on Browse, and then selecting a custom file.
  
  Image AddedLog Setting. Indicates the location where the IDERA Schema Compare log files are saved.
  Image Removed

UI Preferences

• Comparison Grid. Allow you to adjust the behavior of the comparison results grid based on your preferences.
• Script Differences. Allow you to change the highlight color for the script differences as well as determine how the default constraints are scripted. The way the default constraints are scripted has no bearing on the comparison results or on the synchronization script, the only difference is on where you see those constraints scripted. By embedding the default constraints in the table script it is easier to see why two columns might be marked as different. If the default constraints are scripted separately then you might see two seemingly identical columns marked as different and you will need to scroll down below the table script to see what is different.
  Image Removed

Workspace

Contains settings related to the workspace and comparison sessions.

• 
  
  Image Added

Workspace

• Comparison Sessions
  • Save comparison sessions. Selected by default
  Sessions
  • Save sessions. By default is checked. It instructs the IDERA Schema Compare to save comparison sessions for future use. A saved session contains all the necessary information so that you can rerun the comparison with one click. Saved sessions appear on the main panel of the Workspace tab. 
  • Max sessions kept in history. By default, IDERA Schema Compare keeps the last 25 100 comparison sessions. Although there is no noticeable performance difference on application launch related to the number of sessions stored, you may choose to set this parameter to a lower number. Allowable values are 1 to 25100. 
  • Sort sessions by: change Change the order in which the stored sessions appear in on the Workspace tab.
• LayoutAllows you to custom session coloring. Change the color schema of a session. You can select from built-in color schemas or pick custom colors.

Image RemovedImage Added