More Features in ADS 7.5 (Revision #97)

Editor Enhancements

Middle Mouse Close	Save All

Aqua Data Studio 7.5 has a number of new features for all editor tabs:

• Tab Close with middle mouse click - You may now close editor tabs by clicking with the middle mouse button instead of selecting the tab and clicking on the X. This feature is similar to other tabbed document applications such as web browsers and development IDEs.
• Save All - When closing all editor tabs with any that are modified, an additional option has been added to Save All.

Debugger

Load and Save	Go To Combo Box

• The debugger and procedure editor has been enhanced to allow users to save and load parameter values. You can save and load parameter values, preventing the user from retyping values in reoccurring use.
• Oracle Package debugger now includes the "Go To" combo box. This new feature is designed with usability in mind. You can quickly move to any procedure or function within the editor.

Server Registration Enhancements

Schema Browser	Scripting

Server Registration in Aqua Data Studio 7.5 has the following refinements:

• Advanced Tab now has the option to display schema objects in the format of "Name (Schema)" allowing the schema browser to be browsed in sorting order of the object name and not the schema name.
• New preferences in File->Options->Scripting:[Statement Separator] is now database specific. It is now 'Scripts-> [DBMS type]'.  Allowing for the configuration of a statement separator by database type.

Schema Compare Enhancement

Schema Compare now has an option to Order Table Columns by name. This allows for a logical comparison of a table, where the order of the columns has no effect on the equality.

Schema Compare

Logging Enhancement

The Log Viewer is enhanced in Aqua Data Studio 7.5 with a startup.log to troubleshoot problems. It’s available in the Help menu (under View Log->Archive) and works independently from Aqua Data Studio’s normal log file.  This file is created each time the application is started, and contains the following information: Aqua Data Studio version, Operating System Version, CPU count, Memory settings, and Java Virtual Machine properties.

SQL History

Now there is an option to enable SQL History on Visual Editing.  All DDL of schema changes made with the Visual Editors will be stored in SQL History.

Visual Editing	SQL Archive

The SQL History now has a column of Execution Time allowing for quicker profiling of queries. A new option to enter the maximum number of SQL statement executions stored in SQL Archive is now available. An option for the time period between SQL Archive cleanup sweeps is another enhancement in History.

Detail View

The Detail Views for the schema browser now have the Aggregate Toolbar for quick calculations.

Aggregate Methods

Line and Colum number for errors in Oracle SQL Statements

The Query Analyzer for Oracle Server now displays Line and Column numbers for any errors in SQL Statements.

Line & Column Numbers

Line number for errors in SQL Server SQL Statements

The Query Analyzer for SQL Server now displays Line numbers for any errors in SQL Statements.

Line Numbers