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
Most relational database vendors has features to write log files of your SQL queries and other database maintenance operation, but reading the logs are quite difficult. Aqua Data Studio 11.0 introduces a visual log GUI named SQL Log, to capture all SQL queries executed in the Query Analyzer. Once you execute queries in the Query Analyzer, you can view the log data in the GUI or view in Excel spreadsheet. You can also save the log as a text file and open with ADS text editor. SQL Log is a powerful tool that provides a syntax highlighter as well as support for Exceptions in queries.
/* delete business workflows require the same files, databases and command-line terminals to be accessed multiple times every day. Keeping dozens or hundreds of them organized and readily available takes time that could be spent working. If these frequently-accessed scripts, SSH connections and QA environments aren't available in a few clicks, valuable time is lost as users search and browse to find them. We've introduced Shortcut Toolbar Folders to make accessing and organizing those most-used files, databases, scripts and queries even faster. */
The SQL Log For faster access to files, servers, AquaScripts and URLs, the Aqua Data Studio IDE allows creating and grouping shortcuts into Shortcut Toolbar Folders. Organizing shortcuts into folders means an entire folder's worth of content (SSH terminals, Databases, Files, Web URLs) can be opened immediately with a single click. Items in the Shortcut Toolbar can be rearranged, deleted or have their properties altered via the Shortcut Toolbar Manager. Think of the Shortcut Toolbar as a web browser bookmark tool for Aqua Data Studio.
SQL Log GUI
The Shortcut Toolbar can be managed and organized by right clicking the application toolbar and selecting Configure Shortcut Toolbar. Here a user may drag and drop shortcuts from one folder to another or create, reorder and delete folders. Individual shortcut properties can also be edited with a right click to change their names and links. By reordering shortcuts and folders, their display order in the toolbar can be changed. Altering items in the Toolbar Manager immediately alters what is displayed in the Shortcut Toolbar.
|
Shortcut Toolbar Configuration |
Shortcut Toolbar Manager New Folder |
Shortcut Toolbar |
Toolbar Manager Shortcut Properties |
Shortcut Toolbar SSH Connections |
Status
Folders allow grouping shortcuts for better organization. Shortcuts within a folder display as dropdown menus once the folder is "left-clicked" in the Shortcut Toolbar. How the shortcuts stack is configurable from within the Toolbar Manager.
| Shortcut Folders |
Shortcut Toolbar New Folder |
Time and Duration
Once several shortcuts have been placed in a folder, all of a folder's shortcuts can be opened at the same time through the use of the right-click context menu "Open all in Tabs". As an example, all of a user's PostgreSQL database connections can be grouped in a single folder and opened simultaneously in separate tabs with a single click.
|
Shortcut Toolbar Database Open All |
Shortcut Toolbar Web Links |
Shortcut Toolbar Web Links Open All |
Statements executed
Shortcuts can be made of Database Server Connections, SSH Servers, Web Hyperlinks and files. Files from the outside of the application in the Operating System and Web Hyperlinks from web browsers can also be dragged into the toolbar.
|
Shortcut Toolbar Drag and Drop |
Exceptions
Shortcuts can be made of Database Server Connections, SSH Servers, Web Hyperlinks and files. Files from the outside of the application in the Operating System and Web Hyperlinks from web browsers can also be dragged into the toolbar.