SQL Queries & Analysis Tool

Aqua Data Studio brings you an advanced Query Analyzer that allows you to connect to any database server and execute SQL Queries. SQL Abbreviations, Automate and Autocomplete features save you time in writing SQL statements. Use the available Beautify options to format the SQL statements. Query results can be viewed as an Excel spreadsheet or shared as an Email attachment with a single click. SQL Scripts display Inline diff indicators in the Query window with Aqua Data Studio's Version Control Integration. A Charting Toolkit is available in the Grid and Pivot Grid Results.



Aqua Data Studio Query Analyzer includes the following features:

Connect to a Database Server and Execute Queries

Ctrl+Q invokes a Query Analyzer window with a connection to a Database Server. Execute SQL queries using Ctrl+E and view the results in different modes: Grid, Pivot Grid, Form and Text. Additional options to view the Execution Plan, Client Statistics and Script Details are also available. Powerful database management.screenshots - Connect to a Database Server and Execute Queries Text Results | Grid Results | Pivot Grid Results

Automate Query Writing

With one click, the built-in Automate functions allow inserting frequently used statements such as SELECT, DELETE or INSERT in your code. Another powerful and flexible feature is the Abbreviation support under File->Options->Editors->Abbreviations, which allows for user-defined autocompletions. With an easy-to-remember abbreviation, lengthy blocks of SQL can be autocompleted with a few keystrokes.Automate Query Writing screenshots Abbreviation Support

Plain Text Editor Features Enhanced in 18.0

Aqua Data Studio editors are a powerful tool for creating and modifying your scripts and other source code. Aqua Data Studio supports SQL, AquaScript, Text, HTML, XML, JavaScript and Java Editors. Features such as syntax highlighting, autocompletion, code folding, find and replace, lens mode, zooming, punctuation completion and much more are supported.Text Editor with Syntax Highlighting screenshots Syntax Highlighting | Autocompletion | Code Folding | Find and Replace | Lens Mode | Zoom | Punctuation Completion | Encoding

Execute SQL Queries for Editing Tables Enhanced in 18.0

Ctrl+Alt+Enter invokes the query results in an editable, Excel-like grid. The Execute Edit feature is useful for altering, inserting, deleting, cloning and formatting data in the Table Data Editor.screenshots - Execute SQL Queries for Editing Tables Execute Edit Table Data Editor

Visual Explain Plans for Amazon Redshift, DB2, Oracle,
SQL Server, Sybase ASE, Sybase IQ Enhanced in 18.0

Aqua Data Studio’s Visual Explain Plans for Amazon Redshift, DB2 LUW, DB2 z/OS, Greenplum, MS SQL Server, MySQL, Netezza, Oracle, ParAccel, PostgreSQL, Sybase ASE, Sybase ASE, and Teradata Aster provide a visual display and statistics of an execution plan for a query, allowing for query tuning to enhance query and server performance. For Amazon Redshift, DB2 LUW, DB2 z/OS, MS SQL Server, Oracle, Sybase ASE and Sybase IQ, a rich graphical display is also supported. The explain diagrams generated from graphical execution plans can be saved as JPEG or PNG images.screenshots - Visual Explain Plan for Amazon Redshift, DB2, Oracle, and SQL Server Amazon Redshift | DB2 LUW | DB2 z/OS | Oracle | SQL Server | Sybase ASE | Sybase IQ

Version Control Integration

Aqua Data Studio provides integration with several Version Control Systems like CVS,1 Subversion (SVN),2 Git3 and Perforce. 4 SQL Scripts associated with a Version Control repository can be edited and saved in the Query Analyzer. The inline difference sidebar of the editor automatically displays the differences between the currently edited script and its corresponding script in the repository as new text is being typed. Version Control Integration Screenshots Version Control Integration

Autocomplete Object names Enhanced in 18.0

Speed up the creation of your SQL scripts with the autocompletion5 feature for database tables, columns and views. Autocompletion is invoked instantly as you type in the Query Analyzer. Aqua Data Studio will display a pop-up list of all matching object names making your work faster.Autocomplete Object names screenshots Editor with Autocompletion Options

Format SQL Queries

The Query Analyzer allows you to quickly format SQL statements for readability. Ctrl+B invokes the various options to beautify SQL keywords, case keywords, alignments, operators, punctuation marks, line breaks and indentation.Format SQL Queries screenshots SQL Formatting Options

Pivot Grids and Charts

Pivot Grids and pivot tables6 allow users to quickly summarize and analyze large amounts of data in tables—independent of how the data was originally laid out—by including different rows, columns, or summary positions. You can enable Charts in the Query Analyzer to create a graphical representation of your resultset using File->Options->General->Chart->Support Charts.Pivot Grids and Charts screenshots Pivot Grid Chart

Save SQL Query Results to Excel/XML/HTML/CSV/INSERT

Once a query is built and executed, results can be saved as Delimited Data, INSERT statements, XML documents, HTML documents or Excel worksheets.Save SQL Query Results to Excel/XML/HTML/CSV/INSERT screenshot Grid Results Save As

Parameterized Scripts

With the Parameterized Scripts feature, you can define variables in your SQL Scripts using a leading "&". Once you run the script, a popup will prompt you to enter the value of the parameters. This feature allows you to reuse a script with different input values.Parameterized Scripts screenshots Parameterized Scripts

References

  1. ^ CVS Wikipedia article. CVS - Concurrent Versions System is an open source version control system.
  2. ^ SVN Wikipedia article. SVN - Apache Subversion is a free software versioning and a revision control system distributed under Apache License.
  3. ^ Git Wikipedia article. Git is a free distributed revision control system distributed under the terms of the GNU General Public License.
  4. ^ Perforce Wikipedia article. Perforce is a commercial, proprietary, centralized revision control system developed by Perforce Software, Inc.
  5. ^ Autocompletion Wikipedia article.
  6. ^ Pivot Table Wikipedia article.

Home Aqua Data Studio Aqua Data Server AquaClusters Support Buy Company Privacy

Copyright © 2001–2017 AquaFold, Inc. All Rights Reserved.