SQL Log Capture (Revision #18)

Most relational database vendors have 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.

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

 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

 Time and Duration

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

 Statements executed

Option to view the SQL statements executed

 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