SQL Log Capture (Revision #12)

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.

SQL Log

Analyze SQL Statements and view database transactions

The SQL Log for faster access to log files, view time and suration of the statement to finish executionened 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

 

Aqua Data Studio 11.0 features a new Option to view the SQL log files under Help --> SQL Log

Shortcut Toolbar Configuration

Shortcut Toolbar Manager New Folder

Shortcut Toolbar

Toolbar Manager Shortcut Properties

Shortcut Toolbar SSH Connections

 

 Start Event Capture

Displays the status of the SQL statements

 

 Stop Event Capture

Displays the status of the SQL statements

 Status

Displays the status of the SQL statements

Shortcut Folders	Shortcut Toolbar New Folder

 Time and Duration

 

Option to view the time of execution and the duration of the SQL statements

Shortcut Toolbar Database Open All

Shortcut Toolbar Web Links

Shortcut Toolbar Web Links Open All

 Statements executed

Option to view the SQL statements executed

Shortcut Toolbar Drag and Drop

 

 

 Exceptions 

Option to view the SQL exceptions

 View as Spreadsheet 

 

Option to view log as spreadsheet

 Save Log as Text file 

Option to save the log as text files

 Print Log Files

 

Option to print the log files

 

 Clear Display

Clears the display of executed statements and exceptions

 

 Filter

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