Other Features (수정 #47)

Aqua Data Studio 11.0 has many new enhancements for Sybase ASE Server, SQL Server Agent jobs, Charting Tool and the Editor.

Sybase ASE Role Permissions Support

Permissions of Roles within Sybase ASE are now included in CREATE, ALTER and DROP when using Script to Window on Server Roles and Database Roles Schema Objects.

 

sysusermessages contains one row for each user-defined message that can be returned by Adaptive Server.

 

Added Messages Node to Sybase ASE Tree as a database object.

 

Added Extraction of objects for detail view.

added extraction and scripting of DDL information of message object.

the message object is a database object with a key of messagenumber & language.

Sybase ASE User Defined Messages Support

The Sybase ASE Schema Node Tree now displays Messages objects allowing visual DROP and CREATE as well as scripting the DDL of Message DROP and CREATE to a query window.  Clicking on the Messages Schema Object Container displays Message details when the Detail View is enabled.

 

script database user will script aliases for that user

script server user will script the aliases it has to database users

Sybase ASE Alias Support

Scripting database users will script the aliases for users. Scripting Server Users also script aliases for its database users.

 

Thresholds have been added to the tree under there parent database.segment

Sybase ASE Database Segment Threshold Support

Thresholds now appear within the Schema Node Tree underneath Database Segments.

// Add support for datatypes BIGDATETIME, BIGTIME and TIME in Sybase ASE 15.5 only

// SSH Server nodes in the tree need to have an "Open" action and a "Connect" action.  Open will open a terminal window, while the connect will expand the server tree

// When editing a job in SQL Server Agent, need to display the status

SQL Server Agent Job Status

When editing an SQL Server Agent Job, the status of the Job is displayed in the Alter Job Dialog via right click in the Schema Node Tree or in the SQL Server Agent DBA Tool.

Add option to change background color of chart.  We currently can change the background color of the Chart Panel, but not the actual chart.

introducing Fill Grid Color only ?

Fill Grid Color

The fill color within a chart can be set within the Chart Options to whatever color you chose.

 

// Add support for chart legend to display the items in horizontal layout

// Chart enhancement : Legend : space the chart type icon, color icon & series name more evenly

Chart Legend Horizontal Display

When a Chart Legend is set to display at Bottom Center within Chart Options, the Legend itself displays horizontally.

 

New Shortcut - Alt + Down Arrow Editor Context Menu

Using the Alt + Down Arrow keyboard shortcut within an editor displays the appropriate context menu for that editor.

 

New Option - Open in Current Window

Right clicking on any file in the Files browser or Projects Browser allows you to "Open in Current Window" so that the file contents are sent to that window. This means you can send the contents of a file to an editor or Query Analyzer without actually opening the file.

 

New Option to Paste to Window

By right clicking on one or more column cells in the Query Grid Results view you now have the option of sending the selected cells to the Query Window as:  Column Select, IN Values, SELECT  Rows from Void, SELECT Column Body, INSERT Body, UPDATE Body. Choosing any of these generates the appropriate DDL and includes the highlighted values from the Grid Results.

 

Grid Results Hide/Unhide Columns

A new option to right click in a Grid Results Column Header and to choose which Table Columns to display in the Results. This makes it much easier to pare down displayed results without having to change the SQL statement and reexecute.