4.1 Menus and Toolbar

File

• New Document - Creates a new document, but requires that a query window be open first.
• Open Document - Opens an existing document.
• Close Document - closes the currently active document.
• 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.
• New Editor Window - Opens a new editor.
• Print - Provides options for printing the current document.
• Mount Directory - Allows the selection of a directory for mounting in the Script Browser.
• Unmount Directory - Removes a directory from the Script Browser.
• New Frame Window - Launches a new instance of Aqua Data Studio from within the same JVM (Java Virtual Machine)
• Options - Opens the application Options window.
• 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.
• 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 contents of the query analyzer in a new query analyzer tab.
• Querw Analyzer Window - Launches the query analyzer in a new window.
• Query Builder - Launches the query builder.
• 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.
• 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 Execution Plan - Displays execution plans.
• Show Client Statistics - Displays information on the execution of a query relating to the client.
• Show Script Details - Determines whether detailed information on the execution of scripts are displayed.

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.
• Comment Statement - Comments out the current statement.
• Comment Line - Comments out the current line.
• Uncomment Comment - Removes the comments on a statement or selection.
• 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.

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.
• 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.
• 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 Server Browser - Hides, reveals the Server Browser.
• Show/Hide Panel Toolbar - Hides, reveals the Panel Toolbar.
• 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.
• Online Documentation - Launches the default web browser and opens the documentation for Aqua Data Studio.
• Mailing List - Launches the default web browser and opens the Aqua Data Studio mailing list discussions.
• 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.  (Logging month/day per Tanya’s request).

  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.

• License - Displays the Company Name and License Key, also displays Evaluation Request Information
• About Aqua Data Studio - Displays current version, Copyright, System, Fonts and JDBC Drivers information.