Menus and Toolbar

File

• New - Creates a new document based on what is selected from the menu list:
  • Query Analyzer
  • Text Editor
  • HTML Editor
  • XML Editor
  • JavaScript Editor
  • Java Editor
  • Image Viewer
  • Query Builder
  • ER Model
  • Project
• Open - Opens an existing document.
• Open Recent - Displays a list of the10 most recently opened files. Selecting one from the menu list opens it.
• New in Current Window - Prompts to Save As, Save All, Discard or Cancel what is present in the tab in focus. If anything but Cancel is chosen, it then clears the tab of all contents.
• Open in Current Window - Prompts to Save As, Save All, Discard or Cancel what is present in the tab in focus. If anything but Cancel is chosen, it Replaces the content of the current tab with the chosen file.
• Save - Saves the active document.
• Save As - Saves the active document prompting for a different name and destination.
• Save All - Saves all open documents.
• Save Results - Saves results of a query.
• Print - Provides options for printing the current document.
• Mount Directory - Allows the selection of a directory for mounting in the Files Browser.
• Unmount Directory - Removes a directory from the Files Browser.
• New Window - Launches a new instance of Aqua Data Studio from within the same JVM (Java Virtual Machine)
• Set Window Title - Changes the text in the Application Title bar
• Proxy Settings - Opens the Proxy Settings Dialog
• Options - Opens the application Options window.
• Close Window - Closes the current Frame Window ( if only one is open, it exits Aqua Data Studio)
• Exit - Exits Aqua Data Studio.

Edit

• Cut - Cuts the currently highlighted or selected text to the clipboard.
• Copy - Copies the currently highlighted or selected text to the clipboard.
• Paste - Pastes the currently copied text from the clipboard into an insertion point or over currently highlighted or selected text.
• Paste ... - Paste History, allows items stored in the clipboard history to be selected for pasting.
• Undo - Undo the last action.
• Redo - Puts the last undone change back.
• Select All - Selects all of the currently active document.
• Incremental Find - Launches Find dialog and searches for one instance of the search term at a time.
• Find - Launches the Find dialogue to allow searching of the currently active document.
• Find Next - Finds the next instance of the search term.
• Find Previous - Find the preceding instance of the search term.
• Replace - Find instances of the search term and replace them with entered text.
• Go To Line ... - Allows the user to move to a specific line within a document.
• Toggle Bookmark - Hide or reveal a bookmark
• Previous Bookmark - Move to the previous bookmark
• Next Bookmark - Move to the next bookmark
• To Lower Case - Changes the currently selected text to lower case.
• To Upper Case - Changes the currently selected text to upper case.

Server

• New Server Group - Creates a new container for organizing registered servers.
• Delete Server Group - Deletes a Server Group.
• Register Server Clone - Copies the currently selected server’s settings and leaves the name blank so the user can duplicate server settings under a different name.
• Register Server - Allows the user to register a new database server by providing its settings.
• Register SSH Server - Allows the user to register a new SSH server by providing its settings.
• Unregister Server - Removes a server from the list of registered servers.
• Server Properties - Lists the properties of the currently selected server.
• Connect - Connects to the currently selected server.
• Disconnect - Disconnects the currently selected server.
• Query Analyzer - Launches the query analyzer with the currently selected server and database.
• Query Analyzer Clone - Duplicates the query analyzer in a new query analyzer tab.
• Query Analyzer Clone with Content - Duplicates the query analyzer and all of its content in a new query analyzer tab.
• Query Analyzer Window - Launches the query analyzer in a new window.
• Query Builder - Launches the query builder.
• FluidShell - Launches the FluidShell.
• Execute - Executes the statements written in the query analyzer.

Query

• Parse - Parses the query.
• Execute - Executes the query.
• Execute Current - Executes the currently selected query.
• Execute Edit - Executes an edit.
• Execute Explain - Executes an explain.
• Stop - Stops the currently running query.
• Describe - Describes the definition of the tables in current query identified by the position of the cursor in the editor.
• Auto Commit - Determines whether each statement executed is committed after execution or whether a manual commit is required.
• Commit - Commits any executed SQL statements.
• Rollback - Rollback any executed SQL statements not yet committed.
• Reconnect - Reconnects to the currently selected server and database.
• Disconnect - Disconnect from the currently selected server and database.
• Change Server - Allows choosing a different server.
• Auto Complete - Enables and disables Auto Completion.
• Auto On All Schemas - Autocompletes on all schemas.
• Refresh Auto Schema - Refreshes Auto Schema.
• SQL History - Opens the SQL History Archive, displaying its contents.
• Show Text - Displays results as text.
• Show Text History - Determines whether the Text History results tab is displayed, which contains a history of results.
• Show DBMS_OUTPUT - Determines whether the DBMS_OUTPUT results for Oracle are displayed.
• Show Grid - Displays results as a grid.
• Show Pivot Grid - Displays results as a pivot grid.
• Show Form - Displays resuslts as form results.
• Show Execution Plan - Displays execution plans.
• Show Client Statistics - Displays information on the execution of a query relating to the client.

Automate

• Introduce Insert Stmt - Inserts text into editor of a simple INSERT statement template.
• Introduce Update Stmt - Inserts text into editor of a simple UPDATE statement template.
• Introduce Delete Stmt - Inserts text into editor of a simple DELETE statement template.
• Introduce Select Stmt - Inserts text into editor of a simple SELECT statement template.
• Introduce Columns - Inserts text into editor consisting of a list of columns belonging to the tables in the current SQL statement identified by the cursor position.
• Introduce Qualified Columns - Inserts text into editor consisting of a list of fully qualified columns belonging to the tables in the current SQL statement identified by the cursor position.
• Introduce Value Stubs - Inserts text into editor consisting of a list of text and numeric values matching the datatype of columns belonging to the tables in the current SQL statement identified by the cursor position.
• Toggle Statement Comment - Comments/Uncomments the current statement.
• Toggle // Line Comment - Comments/Uncomments the current line using / / .
• Toggle -- Line Comment - Comments/Uncomments the current line using -- comments.
• Toggle /* Block Comment - Comments/Uncomments /* block comments.
• Morph to Upper Case - Converts all selected text to Upper Case.
• Morph to Lower Case - Converts all selected text to lower case.
• Morph to Delimited List - Converts a list of items into a delimited list.
• Format Current Statement - Formats the current statement.
• Format Script- Formats the current script.

Query Builder

• New - Launches a new Query Builder window.
• Open - Opens an existing Query Builder file.
• Open Recent - Opens recently opened Query Builder files

Visual Analytics

• New - Launches a new Visual Analytics window.
• Open - Opens an existing Visual Analytics file.
• Open Recent - Opens recently opened Visual Analytics files

Tools

• Import Data - Opens the Import Data window.
• Export Data - Opens the Export Data window.
• Schema Script Generator - Generates scripts from schema objects.
• Server Script Generator - Generates scripts for server use, such as backups and jobs.
• Object Search - Opens the Object Search window.
• Compare Tools
  • Schema Compare - Compares selected schema.
  • Tab Compare - Compares the contents of application tabs (currently open documents).
  • Directory Compare - Compares two directories.
  • File Compare - Compares two files.
  • Copy Compare - Compares clipboard history items.
  • Results Compare - Compares query results.
• Compress Tool - Opens the Compress Tool for extracting, creating zips, tar.gz files
• Key Generator - Opens the Key Generator for creating Public/Private Key pairs
• Explain Whiteboard - Displays multiple explain plains simultaneously for comparisons of explain plans.
• Execution Monitor - Gives status and statistics of query executions.

DBA Tools

• Oracle
  • Instance Manager - Provides manageability of the Oracle instance allowing the user to view and modify server parameters. Including the monitoring and backup of the Oracle controlfile.
  • Storage Manager - Provides manageability of the Oracle tablespaces and datafiles. Allowing a user to visualize and maintained storage. Including object and file IO statistics.
  • Rollback Segment Manager - Provides the monitoring and maintenance or rollback segments, including current statements, transactions and execution plans.
  • Log Manager - Provides manageability of Redo Logs and Archive Logs. Allows users to create and manage redo logs including monitoring archive logs.
  • Security Manager - Provides manageability of users, roles and profiles. Allowing the user to manage permissions, roles and security of the Oracle database.
  • Session Manager - Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
  • SGA Manager - Provides manageability of the Oracle SGA area, including SQL Area, Lib Cache, Lib Cache Stats and a summary of the SGA. Allowing users to also pin and unpin code.
  • Server Statistics - Provides a summary of statistics for the Oracle instance, waits and latches.
• DB2 LUW
  • Instance Manager - Provides manageability of the Sybase instance allowing the user to view and modify server parameters and viewing server version information.
  • Storage Manager - Provides manageability of the Sybase databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
  • Security Manager - Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of the Sybase database.
  • Session Manager - Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.
• SQL Server
  • Instance Manager - Provides manageability for the MS SQL instance allowing a user to view and modify server parameters and to view server version information and the server logs.
  • Storage Manager - Provides manageability for the MS SQL databases and datafiles allowing a user to visualize and maintain storage including backup devices.
  • Security Manager - Provides manageability for logins, server roles, users, roles and profiles allowing a user to manage permissions, roles and security of the MS SQL database.
  • Session Manager - Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
  • SQL Server Agent - Provides manageability for the SQL Server Agent. This includes operators, jobs and alerts.
• Sybase ASE
  • Instance Manager - Provides manageability of the Sybase instance allowing the user to view and modify server parameters and viewing server version information.
  • Storage Manager - Provides manageability of the Sybase databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
  • Security Manager - Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of the Sybase database.
  • Session Manager - Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.
• MySQL
  • Instance Manager - Provides manageability of the Sybase instance allowing the user to view and modify server parameters and viewing server version information.
  • Storage Manager - Provides manageability of the Sybase databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
  • Security Manager - Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of the Sybase database.
  • Session Manager - Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.

ER Modeler

• New - Creates a new Entity Relationship (ER) Diagram.
• Open - Opens an existing Entity Relationship (ER) Diagram.
• Open Recent - Displays a list of the 10 most recently opened files. Selecting one open its.
• Generate - Generates an Entity Relationship (ER) Diagram based on the objects selected in the Schema Browser.

Window

• MultiTab/SplitPane Results - Switches between SplitPane view and MultiTab view when multipled documents are open.
• Show/Hide Application Toolbar - Hides, reveals the Application Toolbar.
• Show/Hide Query Toolbar - Hides, reveals the Query Toolbar.
• Show/Hide Editor Window - Hides, reveals the Editor Window.
• Show/Hide Query Results - Hides, reveals the Query Results.
• Show/Hide Tree Panels - Hides, reveals the Tree Panels.
• Show/Hide Panel Toolbar - Hides, reveals the Panel Toolbar.
• Show/Hide File Tree - Hides, reveals the File Tree
• Show/Hide Project Tree - Hides, reveals the Project Tree
• Next Tab - Shifts focus to the next document.
• Previous Tab - Shifts focus to the preceding document.
• Next Inner Tab - Shifts focus to the next inner tab.
• Rename Current Tab - Allows renaming of the currently active document tab.
• Close Current Tab - Closes the current tab.
• Close All But Current Tab - Closes all tabs but the currently active tab.
• Close All Tabs - Closes all tabs.
• Tab Focus Top/Bottom - Swaps focus from the tab top or bottom.
• Focus Tree/Document - Swaps focus from the currently active document to the document tree, or vice versa.

Help

• Key Assist - Opens the Key Assist window.
• Technical Support - Opens the AquaFold Support page in a web browser.
• Answers - Launches the default web browser and opens Aqua Data Studio's AquaClusters Answers page.
• Online Documentation - Launches the default web browser and opens the documentation for Aqua Data Studio.
• Community Discussions - Launches the default web browser and opens Aqua Data Studio's AquaClusters Discussions page.
• SQL Log - Launches the SQL Log and begins recording any SQL Queries executed by Aqua Data Studio.
• View Log - Launches Help Log and Console for error troubleshooting. The log begins capturing when it is launched.

  By default, a rolling file logger is always enabled to ~/.datastudio/datastudio.log

  This logger is configured to write up to 3 files of up to 300KB each, using "%d{M/d HH:mm:ss.SSS} %C{1}.%M %m%n layout. 

  This logger can be turned off by placing logger.config file into ~/.datastudio directory.  This file overrides built-in configuration and offers the developers or end users virtually unlimited configuration choices.

• Memory Monitor - Launches the memory monitor which displays RAM usage, application and JVM memory consumption. 
• License - Displays the Company Name and License Key, also displays Evaluation Request Information
• Support Information - Displays information about your installation which can be copied for emailing AquaFold with support issues.
• Kerberos Information - Displays the current Kerberos configuration information and configuration files.
• About Aqua Data Studio - Displays current version, Copyright, System, Fonts and JDBC Drivers information.