Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Server Registration : Permission - Added a permission for SQL Debugger. Determines if a user may open the SQL Debugger on any procedure on this connection. [TBD: Talk to Niels]
| Debugging Permission |
Open Recent: Aqua Data Studio now supports a "Recently Opened" menu item in the File menu. This stores the last 10 files that have been opened, so the user can quickly access any recently opened files.
| Open Recent |
Source Control Status Indicators : Source Control Status now displays more vividly. It also includes "nonversioned" indicators for items within local repositories that have not been committed to the remote repository.
| Source Control Status Indicators |
SVN Commit : You may now multi select objects, right mouse click and check/uncheck objects.
| SVN Multi Select |
| Select Objects for Template Script |
Write Template Script |
Generated Template Script |
New "Form" Results Tab : Displays database results as records with column names on the left and value on the right, as if the information was appearing in a form. Next and Previous buttons allow cycling through the records. Records can also be viewed by entering a record number.
| Form Results |
Configurable Query Results Pane: The Query Results Pane now allows the user to rearrange the result type tabs (Text, Grid, Pivot Grid, Form, etc) in the order desired. The order of the tabs will persist accross appliction restarts. This allows the user to choose the result types desired and choose the primary results tab in the first tab location as the default result to view.
| Results Tab Reorder |
Pivot Grid Custom Filter - Day Option Added: If your Pivot Grid contains a date field as a Filter Field, then the Custom Filter dropdown for your date field now contains a new set of conditions that allow you to filter "on" the days of the week.
| Pivot Grid Custom Filter |
Pivot Grid Custom Filter Days |
Toggle Commenting Out Source Code: Added 3 additional menu action items under Automate menu option to facilitate quickly commenting out code. Added [Toggle // Line Comment], [Toggle -- Line Comment] and [Toggle /* Block Comment].
| Toggle Comments |
Support in PostgreSQL for Table and Column comments for Scripting DDL, Visual Editing and ER Modeler.
| PostgreSQL Comments |
Script Object Permissions for User: We have added the ability to generate a script that sets Object permissions for a given user. This functionality is invoked by right-clicking on a given user, choosing the "Script Object to...." option and then choosing "Grant" (or Revoke to generate a script that removes object permissions). Below is the supported list of database vendors that this feature is compatible with.
(Note: Some databases do not support revoke permission from table/view at column level. Some databases will keep granted permissions in the system data dictionary after user is dropped.)
| Script Object Permissions: User |
Global Date, Time, Date/Time and Decimal Symbol Display Options: By default, ADStudio inherits your OS settings for date/time/number display options. With 8.5, you now have the ability to customize them by going to File -> Options -> General -> Appearance.
| Global Date, Time, Date/Time Options |
Date/Time Format Displayed |
Generate Template Scripts: With this feature, it's now possible to quickly create a script template that will execute against each selected object. Examples include rebuilding a subset of indexes and adding a standardized prefix to all your table names. To use this feature, select multiple objects in the schema browser and right mouse click and choose "Generate Template Script.". You can now enter the SQL statement that you want generated for each selected object.
| Rebuild Multiple Oracle Indexes |