SQL Log Capture (Revision #10)

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. */

SQL Log

Analyze SQL Statements and view database transactions

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.

What's New?

 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.

 Filter

Filter helps you to search and find the executed SQL queries very easily.

 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.

 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.

 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.

 Save Log as Text file 

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.

 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.