• Mac OSX (Aqua Data Studio Look):
  • The new Look and Feel uses the OSX native look for all components to make it indistinguishable from native applications.
  • Screen Menu Bar: The "Aqua Data Studio" menu now includes 'About', 'Preferences' and 'Quit' as menu items.
  • Key Bindings: The entire application and the editor now use native key bindings corresponding to the OSX UI Guidelines.
  • Toolbars: Tooltips for toolbars now have appropriate keybindings distinguishing Ctrl & Apple keys. They are displayed at the end of the tooltip text.
  • Menu Items: in accordance to the OSX UI guidelines they don't use icons or mnemonics anymore.

• Windows (Aqua Data Studio and Aqua Data Studio (Stylus) Look):
  • By default ADS uses the native look and feel that will give a user the full Windows experience. Depending on their preferences, users may instead choose the Aqua Data Studio (Stylus) look to make Aqua Data Studio indistinguishable from any other native application.
  • Menu Items and Dialogs: Now have native support for Windows XP "Alt-Activated" mnemonics. This option may be disabled in Windows OS under Control Panel->Display->Appearance->Effects: 'Hide underlined letters for keyboard navigation until I press the Alt key.'

• Keymappings:
  • Complete Keymappings now allow full access to the application without use of a mouse. They also provide keybindings for each OS according to the Usability guidelines. Detailed new and complete keybinding information is provided in the documentation.
  
  => Documentation: Keymappings
  
  
  • Customizable Keymappings now allow full customization of the keymappings for the entire application. Different profiles may be created according to user preferences. The options are located in File->Options:Key mappings, where the user may create new profiles with customized key mappings.
  
  => Documentation: Keymap Profiles
  

• Tabbed Document Enhancements:
  • Scrollable tabs allow for less clutter by providing a scrollable pane of tabs if you have a large number of open tabs.
  • Tabs can now be reordered. Just click on a tab and drag it to the position desired.
  • Tabs may now be renamed once they have been opened, with keybinding [Ctrl-Alt-T] or [Apple-Alt-T] (right-click a tab to see the options).
  • Tabs may now be expanded/collapsed with a double-click. While working in a tab window, if a user wants to get full screen, he/she may double click on the tab and the tab window will expand. Double clicking again will collapse the tab back to the original size.
  • Top right corner now has an icon which, if clicked, displays a popup menu list of all the tabs in the Tab docs.
  
  
• Tabbed Document Grouping:
  • Create multi-level horizontal and vertical Tab Groups. Right click on any tab to create a horizontal or vertical tab group. This allows users to create various groups of tabs to compare results visually or to reorganize tab windows.
  • Move tabs from group to group, or to a new group by dragging and dropping them. After a user tries to drag a tab, he/she sees a menu prompting if they want to move this tab to another group, create a new group with this tab, change the current group orientation or cancel the action.
  • EXAMPLE: Use Tab groups to compare results in two query windows side by side, or have a DBA Tool and query window side by side.

• Toolbars:
  • Tooltips automatically display the shortcut key at the end of the tooltip text across the entire application.
  • Auto expand/collapse - if the size of the window is too small for the toolbar, then the bar will collapse.
  
  

• New Menu Action Items
  
  File
  • Close Document: Close the currently open document in the current tab window without closing the tab.
  • Save All: Save all documents in the Tab document pane.
  • New Editor Window: Open new editor window. The editor will be of the current type selected in the toolbar.
  
  
  Edit
  • Paste ...: This will provide a user with a dialog displaying the query copy history, allowing the user to select and paste old queries copied in the past.
  • Find Next: Find the next occurrence of the current search.
  • Find Previous: Find the previous occurrence of the current search.
  • Replace: Find and replace item(s)
  
  
  Window
  • Next Tab: Move to the next tab
  • Previous Tab: Move to the previous tab
  • Next Inner Tab: Move to the next (sub-)tab within the current tab
  • Close Current Tab: Close the current tab
  • Close All But Current Tab: Close all but the current tab
  • Close All Tabs: Close all tabs
  • Focus Tree/Document: Move focus to the tree or document pane
  • Tab Focus Top/Bottom: Move focus to the top or bottom component of the split panel in the current tab window.
  
  
  Help
  • Online Documentation: Open browser to display the Aqua Data Studio online documentation
  • Mailing List: Open browser to display the Aqua Data Studio mailing list

Connection Dialog Local Permissions now include permissions for Visual Editing, including CREATE, ALTER, DROP and View Properties. Disabling these permissions will prevent Visual Editing of any schema object for the actual connection.

Application Options: File->Options:General : General, called "Application Scope Maximum Results" which identifies the maximum results returned by Query Analyzer, Table Data Editor and Query Builder regardless of settings specified by a user. The user can also specify maximum number of results returned by a query locally, while using individual tools. However, if the user specified maximum for the tool is greater then the application scope option, then the latter option will be used. -1 indicates an unlimited number of results to be returned.

• File->Options:Registration Defaults: These options give a user the ability to set the default driver parameters for various database types. Those parameters are displayed by default when registering a server.
  
  
• File->Options: Enable Server Directory Mount - This option allows a user (usually, an administrator) to enable/disable Server directory mounting/unmounting, so unauthorized users cannot mount their own directories and copy server objects and permissions.
  
  

• For SQL Server 2005 added Column Permission dialog for Tabular Functions.
  
  
• For SQL Server 2005 added extra permissions to Object and Column permission dialogs.
  
  
• For SQL Server and Informix added a "Grantor" field that allows a user to specify a grantor in the Grant or Revoke SQL statements such as "<SQL> AS <GRANTOR>"

• Object Permission Scripting
  • Objects in schema browser now can include permissions when being scripted as GRANT and REVOKE
  • Table Script "Create FULL" now includes table permissions.
• CREATE Scripting
  • - File->Options:General: Scripting
  • Option to include DROP and GRANT when scripting an object as CREATE.
• SELECT Scripting
  • - File->Options:General: Scripting
  • Option to auto format SELECT script.

• Schema Browser
  • Oracle and DB2 schema browser now have a "My Schema" node to list all the schema objects for the actual user.

Added an option to display customized names of schema objects in the schema tree as either the "Name", "Schema.Name" or the default convention according to the Server type: Oracle(Name), DB2(Name), SQL Server(Schema.Name), Sybase(Schema.Name). The option can be accesses from the menu Schema Browser->Server Properties: Advanced tab.

• Quick Search - Now have quick search feature. If a user starts typing, a tooltip will popup with the text that is being searched. Press "escape" to cancel search and perform other actions.
• Added the Alt-Down hot key to activate a popup menu.

Find and Replace now have support for regular expressions. Regular expressions are pattern descriptions which enable sophisticated matching of strings. In addition to being able to match a string against a pattern, you can also extract parts of the match. Full details on the syntax of regular expression patterns are provided in the documentation.

This new special "Paste..." command allows a user to paste a fragment of text from the history of copy commands issued in the Aqua Data Studio editor in the past. Any time a copy command is issued, the text will be stored in the history to be available to the user for a special paste. The command "Paste..." is available from the Edit menu action items listed above.

The new text editor provides users with the ability to quickly edit SQL files without opening a query window or regular text files without leaving the Aqua Data Studio development environment.

The new HTML editor allows users to easily edit HTML files with syntax coloring for easier editing of files.

The new XML editor allows users to edit XML files within the Aqua Data Studio development environment using the powerful Aqua Data Studio editor including syntax coloring.

File->Options: [ Text Editor | HTML Editor | XML Editor ]

• Tabs
  
  • Expand Tabs - Determines whether a TAB is expandable to spaces or whether a real TAB is used
  • Number of spaces per tab - Number of spaces to expand in a TAB if Expand Tab is enabled
  • Tab Size - The display size in characters of a TAB

• General
  
  • Highlight matching bracket - Highlight a bracket that matches the bracket before the insertion point
  • Highlight caret row - Highlight a row with the current insertion point
  • Highlight caret row color - The color of the current row
  • Status Bar Visible - Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  • Display Text Limit Line - Determines if the text limit line is displayed
  • Text Limit Character Count - Determines the character count after which the text limit line is displayed
  • Line Numbers - Determines if the line numbers in the document are displayed along the left side of the window
  • Highlighted text foreground - Indicates the foreground color of the highlighted text
  • Highlighted text background - Indicates the background color of the highlighted text
  • Insertion Point Blink Rate - Frequency with which the insertion point or overwrite caret blinks
  • Vertical Bar - Insertion point style
  • Solid Block - Style of the caret when in the overwrite mode

The SQL Editor now also provides more customizations to better tailor the editor to the user preference.

File->Options: SQL Editor

• General
  
  • Highlight matching bracket - Highlight a bracket that matches the bracket before the insertion point
  • Highlight caret row - Highlight a row with the current insertion point
  • Highlight caret row color - The color of the current row
  • Status Bar Visible - Determines if the status bar (showing insert mode, line number, and so on) is displayed at the bottom of the window
  • Display Text Limit Line - Determines if the text limit line is displayed
  • Text Limit Character Count - Determines the character count after which the text limit line is displayed
  • Line Numbers - Determines if the line numbers in the document are displayed along the left side of the window
  • Highlighted text foreground - Indicates the foreground color of the highlighted text
  • Highlighted text background - Indicates the background color of the highlighted text
  • Insertion Point Blink Rate - Frequency with which the insertion point or overwrite caret blinks
  • Vertical Bar - Insertion point style
  • Solid Block - Style of the caret when in the overwrite mode

The Procedure and Function Editor toolbar now has an "Open from Database" button to open a new Procedure or Function from the database without needing to open a new window.

Execute parameters dialog now has the 'ENTER' key bound to the "Execute" action

The new Oracle Package Editor allows users to edit packages more easily by providing both the definition and the body in one tab window. The editor also provides a drop down of all functions & procedures in the package for quick navigation.

The new image viewer allows a user to view a list of images in a preview pane and operate on any selected image. The image viewer may be invoked from the Grid Results of the Query Window. A user may query a database for binary/image data and then load it into the image viewer, clicking on "View In... Image Viewer" from the popup menu. Note: to be able to view data as images, the user should deselect the option to view binary data in the HEX format, as unchecking the checkbox in File->Options:Results:'Convert binary to hex'.

The image viewer supports GIF, JPG and PNG file formats.

• General Enhancements:
  • Execute Edit now works across different databases, including querying on fully qualified table names such as Northwind.dbo.Categories.
  • Auto-Describe (Ctrl-D) now also prints out indexes and permissions of a table. The index and permission display can be disabled/enabled in File->Options->General:Describe
  • Print Dialog: (Grid Results): Added support for Printing custom Headers and Footers when using the 'Grid' Output. The user can include Date, Time and/or Page# information as well as custom header and footer text
  • Added an option that allows the user to specify coloring of the status bar in case when there were warnings or errors when running a query, facilitating visual perception of them. This option can be enabled/disabled in File->Options:Results:Status Panel Color. The user can also specify background and foreground colors for warning and error messages displayed on the status panel.
  • Added date and time expressions to parameterized scripts. This feature now allows a user to specify a default value of a parameter to be a date expression. In the File->Options:General:"Parameterized Scripts" the user can specify tags for the date and time expressions and whether to prompt the user if he/she wants to change the default values in the expression. Examples: {d-1y} = 1 year prior to the current date; {dt-2h-3m-8s-340S} = current date and time minus 2 hours, 3 minutes, 8 seconds and 340 milliseconds; {dm+6h} = current date at midnight, plus 6 hours, i.e. today at 6am.
  • Hot Keys
    • Ctrl-Double Click on the Query Editor tab (upper window) now toggles Show/Hide for Query Results, similar to Window->Show/Hide Query Results
    • Pressing Alt-M hot key moves the focus to the Max Results field in the Query Window
  
  
• Query Results:
  • General:
    • Double click on any results tab will expand/collapse results pane
    • Grid Results/History Results: Added autosearch feature. If the user starts typing in the grid autosearch will begin.
      • Search for: companyname ... this will search for any value that starts with "companyname"
      • Search for: *companyname ... this will search for any value that contains "companyname"
      • Search for: ?companyname ... this will match any character and then "companyname"
      • Use up/down arrows to navigate to the previous/next matching occurrence.
      • Hold Ctrl key down and use the up/down keys for multiple selection
      • Use Ctrl-A to find all matching occurrences.
      • Table Selection
        • Shift-End -End of Row (or Rows if more than one is selected)
        • Shift-Ctrl (OSX: Shift-Page Down) -End of Column(s)
        • Shift-Home -Beginning of Row(s)
        • Shift-End (OSX: Shift-Page Up) -Beginning of Column(s)
  • Grid Results:
    • Grid results with several result sets now is displayed as a multi-level splitpane to provide full control of grid sizes for each result set.
    • Results now have an ability to be sorted by multiple columns. Ctrl-click to select multiple sort columns.
    • Grid results popup menu now has a menu item called "View in ..." which allows the user to view the selected cell values in a viewer or editor of choice, whether it is Text, HTML, XML or a set of images. This allows a user to query the database for images and subsequently view them, or to query for XML/HTML data and subsequently view it.
    • A double click allows the user to perform View As Text on the cell.
    • Popup Menu now has "Copy As ..." -> {Comma Separated Horizontal Sequence, Comma Separated Vertical Sequence}
    • The results now have a header with row count and execution stats. The header can be disabled/enabled using the popup menu item "Show/Hide Header".
    • A Quick Filter field has been added at the top right of the results, when the header is shown. Click Alt-Q hot key for Quick Filter activation and Alt-Down for popup menu activation.
    • Clicking on the top left cell (in the Label Row) selects all of the cells in the table.
  • Execution Plan:
    • The Explain plan tree table now has the first column set to be stationary and is always shown as you scroll across the columns of the execution plan.
  • Save Results:
    • Save Results: Dialog options for Data Format INSERT Statements now provides a list of Tables and Schemas that were present in the query so a user can save the results as insert statements to the existing table. It can be useful to migrate tables.


• Permissions:
  • Added an option to specify a custom message to explain why the local permission is set, to be displayed when there is a permission failure. This option can be accessed at File->Options:General:Query Windows: Permission Failure Message.
  • Added fine grain permissions for TSQL blocks, to handle cases when a user has multiple statements and some statements are being executed for temp tables and some are being executed for stationary database tables.

• General enhancements:
  • Added the ability to query across different databases. When a user opens the Add Table Dialog, he/she can select tables from different databases and the Query Builder will generate an appropriate SQL for execution.
  • Now has an ability to save queries to a file and and reopen the file. This allows the user to save working queries for later use, or to share them with other users.
  • Toolbar now has a "reconnect" button to allow users to reconnect to the database in case the connection has been dropped by the database server.
  • When closing the query window the Query Builder now prompts the user to "Cancel", "Discard", "Save" or "Save As".
  • Added Index Panel to show the indexes. When a user clicks on an index, the participating columns are highlighted at the Column Pane.
  • General: Filters button on toolbar now has the option "Database Qualified Tables"; if it's selected, the Preview SQL window will display full database path for table qualification.
  • Toolbar now provides information on "Username:", "Schema:" and "spid:"
  • Added options to save results: "Save" and "Save As"
  • Added navigation to the menubar->Window: Next Pane, Previous Pane, Next Index, Previous Index.
  • Added an option that allows the user to specify coloring of the status bar in case when there were warnings or errors when running a query, facilitating visual perception of them. This option can be enabled/disabled in File->Options:Results:Status Panel Color. The user can also specify background and foreground colors for warning and error messages displayed on the status panel.
  • Added the Table Shortcut toolbar. By default the toolbar is disabled. A user can enable/disable the toolbar from the menu as Window->Show Table Shortcut Toolbar. The user can add a shortcut to a table by right clicking on the table in the diagram pane and selecting "Add to Shortcut Toolbar", and the table shortcut will appear on the toolbar. The user may then click on any shortcut at the toolbar and add the table in the Diagram pane. The shortcuts are not saved and are not persistant accross different Query Builder instances.
  • Hot Keys:
    • Press Alt-D or Alt-M hot keys to gain focus on Database or Max Results fields
    • Press Alt-Left or Alt-Right ( OSX: Cntrl-Left or Cntrl-Right ) to go to the Previous Pane or to the Next Pane; Alt-PgUp (OSX: Cntrl-PgUp) or Alt-PgDown (OSX: Cntrl-PgDown) to go to the previous Index or to the Next Index respectively.
  
  
• Add Table Dialog
  • Dialog has option for column selection. This option allows the user to specify what columns will automatically be selected into the Column Pane for the tables added into the query.
  • Dialog now has database combo box which allows the user to change the context of the database, so that the user may select tables and views from different databases.
  • Under the application File->Options:Query Builder there is now an option to "Show Add Table Dialog at startup" which allows the user to control whether the Add Dialog is displayed automatically when the Query Builder frame is initially displayed.
  • Auto-Find functionality allows the user to type the name of the table for a quick table lookup. The user may also specify a fully qualified table name (e.g. Northwind.dbo.MyTable or Northwind..MyTable) and the auto find will change the database context, refresh the tables and views and auto find the table. One first has to gain focus in the columns/schema pane and then start typing. Only then can one see that there is actually a 'search' going on and what one has typed. Even then there is no 'box' or other means to distinguish what one is typing other than the bare letters against the grey background.)
  • Windows menu now has the option "Limit Add Table to User Schema". The is will limit options in the schema combo box to the user schema. This can provide a performance boost in scenarios when the database has a large number of user schemas and tables, by limiting the list of tables and views to the users objects.
  • Added hot key mnemonics to column selection type options (Column Selection)
  • Hot Keys
    • Press Alt-D or Alt-S hot keys to gain focus on Database or Schema comboboxes respectively.
  
  
• Diagram Pane
  • Table and View panels in the Diagram now have the primary key bolded and indexed columns italicized. This assists the user in identifying candidate columns for criteria creation.
  • Tables in diagram pane now have extra items in popup menu: "Select All Columns", "Unselect All Columns", "Select All Indexed Columns" and "Select Leading Index Column".
  
  
• Column Pane
  • The toolbar and windows menu now have the options "Show Datatype", "Show Index" and "Show Index Order" which will enable/disable the columns in the Column Pane to identify the column datatype, the name of the indexes the column is bound to and the position the column is in the index.
  • Window menu now has the option to place the columns pane into "Quick Criteria Mode" . This will convert the criteria columns into only two columns consisting of the operation and value. Where the "Operator" is a combo box of the items "LIKE, =, IS NULL, NOT NULL, <>, >=, =", and "Criteria" is the column to enter the value
    
  • Window menu: Added "Clear Column Criteria" [Ctrl-Alt-K]
  • Operator combo box now has a "" (i.e. simply a blank string with no quotation marks) as a possible selection.
  • Now has extra items in popup menu: "Move Up", "Move Down", "Move Top" and "Move Bottom" for selected rows.
  • Delete when not in the cell editor will delete the full value of the cell for columns Alias, Operator, Criteria, Or1, Or2, or3 and Group By.
  • Added "NOT IN" to operators in Quick Criteria mode.
  • Delete key on Columns Pane now deletes all the selected cells not just the current one.
  • Hot Keys:
    • When in Cell Editor Shift-Ctrl-Left/Right/Home would close the cell editor.
    • Alt-Down now activates popup menu for combo box cells
    • Ctrl-Alt-K clears Column Criteria
  
  
• Grid Results:
  • Added autosearch feature. If the user starts typing in the grid autosearch will begin similar to the Query Analyzer.
  • Table search is cleared after table is selected with an "enter" key.
  • Added "View In" to popup menu similar to the Query Analyzer.
  • Double click on tab of results will expand/collapse results pane

• General
  • " Edit in window" option now has an extra tab that provides an editor which wraps the text so the user may edit in a regular or a wrapped text mode.
  • "Save SQL" now stores the chosen directory path and uses it for subsequent save operations as a default directory for easier navigation
  • Preview panel: The preview panel now creates a cells preview at the bottom split panel to allow the user to preview the currently selected value in the grid, so that the user may easily see the full value, including long string values or CLOB values.
  • Status Bar now has "Total Rows:" information at the bottom right to show the number of rows in the table.
  • After the changes are saved and the table is refreshed (Save and Refresh), the cursor selects the first cell of the selected row before save.
  • Edit->Format: AutoFit Column Width - Cells can now be highlighted and resized automatically using the menu, a key shortcut, or a double-click on the right border of the column header. This option can be configured from the dropdown menu.
  • Edit->Next Tab: Move to next tab; Edit->Previous Tab: Move to previous tab; Editor->Focus Max Results: Move focus to the max results.
  • File->Options:General: Moved Table Data Editor options to Table Data Editor section.
  • When closing a modified window the application will now prompt for "Save", "Discard" and "Cancel" instead of "Yes" or "No"


• Visual Editing:
  • Inserted/Modified/Deleted rows now have light blue cell background
  • Modified cells now have a slightly darker color for the text, making spaces more visible.
  • Cells in Inserted Rows also have the background color of the text shaded to help identify invisible characters
  • Entering a string value with length longer then the datatype can handle will notify the user of a possibility for truncation.
  • "Paste" now pastes the value from the clipboard into all the selected cells.
  • "Delete Row" is now "Delete Selected Rows" which deletes all the selected rows.
  • Editing a cell with a key stroke will clear the cell and start the cell value from the key typed. Editing the cell with a mouse double click will edit the cell but will leave the old value.
  • Edit->Clone Selected Rows - Clones the selected rows. This option can be also accessed from the dropdown menu.
  • Edit->Insert Current Date Only: Inserts the current date, and a time of 12:00pm if the date type is a timestamp.This option can be also accessed from the dropdown menu.
  • DateTime columns: If the user now enters or pastes a date or datetime in a different format than the default locale, then ADS will make a conversion. Example: 8/9/06 will be converted to 08/09/2006 12:00:00 AM
  • Toolbar: Added buttons for Clone Selected Rows and for Insert Date Only
  • Fill Functionality as Edit->Fill Down and Edit->Fill Right: Fills currently selected cells in the chosen direction with the first selected cell content. This option can be also accessed from the dropdown menu.
  • Pasting into a cell from a spreadsheet:
    • Pasting into a cell in edit mode will trim carriage returns ("/r")
    • If a user copies one cell from a spreadsheet and pastes it into a single cell of the Table Data Editor it will paste the value without trailing carriage returns and line feeds.
    • If the user copies one cell from a spreadsheet and pastes it into a number of selected cells, the Table Data Editor will paste the single copied cell into each individual selected cell.
    • If the user copies a block of cells from a spreadsheet then the Table Data Editor will paste the block into the corresponding cells starting from the leading selected cell; whether a single cell or multiple cells are selected does not change the functionality.
  • A user now can copy a row and then paste the row into an empty row. Select row, press CTRL-C, then select another row and press CTRL-V.
  • A user now can copy any number of rows and paste them into the last empty row and the necessary number of rows will be created to complete the paste.
  • Clear Cell Changes is now "Clear Selected Cell Changes".
  • Find/Replace Options:
    • Edit->Find: Find the first occurrence of the text in the grid values starting from the current position, using the specified direction for search
    • Edit->Find Next: Find the next occurrence of the last find
    • Edit->Find Previous: Find the previous occurrence of the last find
    • Edit->Replace: Finds and replace a string occurrence(s) by a specified string; if it replaces all of the occurrences in the table, show how many have been replaced.
    • Added string matching options for Find and Replace: "match entire cell" and "match whole words"
  • Hot Keys:
    • Quick Selection - Ctrl-Shift-R and Ctrl-Shift-K (by default) now selects all the rows or columns respectively that have cells that are currently selected.
    • Default Key Binding for Delete Row is now Ctrl-Delete, for Clear Changes is now Ctrl-Alt-Z, for Clear Cell Changes is now Ctrl-Alt-Y.
    • Key "Edit" will overwrite, F2 will put in edit mode with text highlighted and mouse double click will put in edit without highlight.
    • DELETE Key: Now will "Set to Null" all the selected cells instead of deleting the row.
    • CTRL-D Key: Now will delete the row

Saving Changes:
• If no results are returned then an error message is displayed.
• Now displays warnings when warnings are returned.
• If a statement is executed that doesn't make any modifications then the transaction is still committed. Ex: Deleting a row which has already been deleted by a different user.
• The table data editor is now threaded and there is a status bar at the bottom that displays the status of execution, including the number of statements to be executed and on which execution it is on. The toolbar now has a cancel button so the user may cancel the execution at any given time.
• If Save is cancelled while being executed, the status bar now displays the total number of statements executed before the cancel.
• Transaction Handling:
  File->Options:Table Data Editor: Added section for Table Data Editor Options
  • Transactions: Transaction Type: {Full, Batch, Threshold} :
  • Full: A "Full" transaction type causes all changes to be made in one transaction. This is the default.
  • Batch: A "Batch" transaction type will batch all the statements to be executed into batches with X number of statements per batch. Each batch will be committed independently. If a commit fails, the execution will stop and rollback the current transaction batch, but will not be able to rollback the previously executed transaction batches.
  • Threshold: A "Threshold" transaction batch executes the statements in order and after each executed statement will check the amount of time elapsed since the beginning of the batch. If the time elapsed has reached the threshold time then the current transaction will be committed and a new transaction will be started. This will allow the statements to be batched in separate transactions based on a time Threshold.
  • Batch Size: Number of statements per transaction batch [For Transaction Type: Batch]
  • Threshold: Number of milliseconds elapsed to trigger a transaction batch commit [For Transaction Type: Threshold]
  • Wait Time: Amount of time to wait between transactions [For all Transactions].
  • Transaction Log Monitor [Sybase ASE]: This will allow ADS to queue editor modifications for Sybase ASE if the Transaction Log percent hits a certain Threshold allowing the server to process the current transactions before receiving requests from ADS.
    • Log Used Threshold: Percent of transaction log used that would trigger a transaction to wait
    • Log Used Wait Time: Time to wait if a transaction log used threshold is triggered.

• General
  • Now provides a preview tab that displays the full SQL that is currently selected in the history list. This preview may be enabled/disabled on the toolbar.
  • Column size and window position are now saved and reloaded when application is restarted.
  • Date column is now formatted according to the locale.
  • Added columns "Server Name", "Tool name", "Start Date/Time ", "End Date/Time ", "Rows Affected" to the SQL History.
  • Columns are now sortable.
  • File>Options:[General:SQL History] Added SQL history options "maximum number of entries" and "maximum number of statements" to determine persistence values, even though values may be temporarily changed in the SQL History dialog.
  • Added to the toolbar a Quick Filter panel to filter the history
  • Added Alt-M hot key to focus on the Max History field, Alt-S to focus on the Max Statements per entry field, Alt-Q to focus on the Quick Filter field. Press "Escape" to regain focus on the table.
  • Added a "Diff" button to the toolbar. If a user selects two rows and clicks on this button, the application will open a Diff Tab for the two SQL Statements to compare them.

• " Find" functionality for both the Grid list and Preview Panel
  • "Find": Find the first occurrence of the text in the grid values starting from the current position
  • " Find Next": Find the next occurrence of the last find
  • "Find Previous": Find the previous occurrence of the last find

• General
  • Added an extra option to allow the overwriting of current scripts instead of generating enumerated script names, when scripting one file per object.
  • Script Generator Dialog - Added "Reverse Selection" to object selection, to reverse the current selection.

• General
  • ER Diagram: Indexed columns are now identified with an icon in the diagram.
  • ER Diagram Generator Dialog - Added "Reverse Selection" to object selection, to reverse the current selection

• General
  • Execution Monitor: Added Execution Monitor that monitors status of all the queries issued in Query Analyzer, Query Builder and Table Data Editor. The monitor has been designed in order to notify a user about long running queries, so he/she can cancel them; and/or it can terminate those queries automatically, as those queries may unnecessarily consume valuable server resources.
  • In the application options, the File->Options:General:Execution Monitor section sets options for the Execution Monitor as query warning time, query stop time and snooze time. The user will be notified when a query runs beyond the warning time, he/she can extend its running time by the snooze time, and the query will be stopped automatically once it reaches its stop time.
  • The monitor dialog opens automatically to warn the user when some query runs beyond the warning time. The user will be able to cancel this query, snooze it, let it run till it's stopped automatically, and clear the query information from the monitor once it's stopped.
  • The user can also open the Execution Monitor from the Tools menu and see all of the queries currently running. The Execution Monitor displays information about the queries including SPID.
  • By default, the Execution Monitor is disabled for queries running from the Table Editor as the table editing already handles long transactions. The user can enable it in the application options as File->Options:General:Execution Monitor: "Enable Execution Monitor for Table Data Editor".

The new schema difference tool provides a user with graphical representation depicting differences between two databases or schemas. It provides a list of objects in each database and the user can select database objects to compare. Object difference is defined as the difference between DDLs for those objects. The resulting panel displays graphically whether the object is identical, different or does not exist in the counterpart database.

=> Documentation: Schema Diff

The new directory difference tool provides a user with graphical representation depicting differences between two directories. Two directories are identical if they have the same subdirectory structure, and files in the directories have the same content, otherwise they are different. Two files are identical if they have the same content. The resulting panel displays graphically whether the directory object is identical, different or does not exist in the counterpart directory. This tool is useful, for example, if the user wants to compare two source code versions for the same product, and see what changes have been made in the later version.

=> Documentation: Directory Diff

The new file difference tool provides a user with graphical representation depicting differences between two files. File difference is defined as the difference in the file content. The resulting panel displays graphically lines in the content that possibly have been deleted from the file, added to the file or have been changed compared to the other file.

=> Documentation: File Diff

The new tab difference tool provides a user with graphical representation depicting differences between two tabs. Tab difference is defined as the difference in the tab text. The resulting panel displays graphically lines in the content that possibly have been deleted from the tab, added to the tab or have been changed compared to the other tab.

=> Documentation: Tab Diff

The new copy history difference tool provides a user with graphical representation depicting differences between two statements copied to the History. Copy difference is defined as the difference in the statement content. The resulting panel displays graphically lines in the content that possibly have been removed from the statement, added to the statement or have been changed compared to the other statement.

• Storage and Session managers now have a Tree Table tab displaying the server content as a tree and the first column (the tree) is always displayed as you scroll the other columns
  
• The toolbar actions of each DBA tool display actions particular for the currently selected sub tab of the tool
  
• All DBA Tools now use the new Sortable Table with a Quickfilter combobox

The MS SQL Server Database Administration (DBA) Tools provide users with tools to administer, manage and monitor all aspects of a MS SQL Server database. The tools may be accessed from the application DBA Tools menu or from the schema browser context sensitive popup menu.

The following is a list of tools provided with a description of each tool functionality.

• 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.
  => Documentation
  
  
• Storage Manager: Provides manageability for the MS SQL databases and datafiles allowing a user to visualize and maintain storage including backup devices.
  => Documentation
  
  
• 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.
  => Documentation
  
  
• Session Manager: Provides manageability for database sessions including user locks that allows a user to monitor and kill sessions.
  => Documentation
  
  
• SQL Server Agent Manager: Provides manageability for the SQL Server Agent. This includes operators, jobs and alerts.
  => Documentation
  
  

The Sybase Database Administration (DBA) Tools provide users with the tools to administer, manage and monitor all aspects of a Sybase database. The tools may be accessed from the application DBA Tools menu or from the schema browsers context sensitive popup menu.

The following is a list of tools provided with a description of each tools functionality.

• Instance Manager: Provides manageability of the Sybase instance allowing the user to view and modify server parameters and viewing server version information.
  => Documentation
  
  
• Storage Manager: Provides manageability of the Sybase databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
  => Documentation
  
  
• Security Manager: Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of the Sybase database.
  => Documentation
  
  
• Session Manager: Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.
  => Documentation