|
|
|
User Rating:
Rated by: |
Good (3.3/5)
32 user(s) |
|
|
|
Aqua Data Studio description
|
SQL Query tool that allows developers to create edit and execute SQL scripts
Aqua Data Studio is a SQL editor and developer utility which enables developers to easily create edit and execute SQL scripts as well as browse database structures.
Aqua Data Studio provides an integrated database environment with a single consistent inferface to all major relational databases. This allows the DBA or developer to tackle multiple tasks simultaneously from one application.
Aqua Data Studio sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test scripts including detailed client statistical information and multigrid results.
Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema at a click of a mouse. It also includes the ability to save your query results in many formats including HTML and XML. Here are some key features of "Aqua Data Studio":
· Query Analyzer/Window
· Aqua Data Studio's sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test SQL scripts. Other features to speed up development include SQL automation, auto-describe and sortable multi-grid results. The query analyzer also provides client side variable binding, allowing a user to execute stored procedures or functions with local variables binded to receive out parameters. The query window also provides two modes of operation, using a SplitPane View or a MultiTab View for the editor and the query results.
· Schema Browser & Visual Editing
· Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema with a single mouse click. The schema browser also allows you to visually edit any schema object with a graphical design form to CREATE, ALTER or DROP the object. Visual editing supports Tables, Indexes, Procedures, Data Types and other schema objects. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.
· Schema Extraction & DDL Scripting
· Its graphical browsing allows you to extract the structure definition of all schema objects and to script the SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database schema objects (including Tables, Views, Triggers, Stored Procedures and Functions).
· Table Data Editor
· A powerful Table Data Editor allows you to modify your results graphically and save them. By writing a single table SELECT statement in the Query Analyzer and clicking on the 'Execute Edit' button, a separate window is opened with the query results for you to edit and save. You may also browser to a table in the schema browser and select the Edit Table from the popup menu to edit the first 1000 records in a table.
Requirements:
· 1GHz x86 Processor or above (Intel/AMD)
· Minimum 256 MB or RAM
· Minimum 100 MB of Disk space
Limitations:
· 14 days trial
· Nag screen What's New in This Release: [ read full changelog ]
Scripting Sybase ASE Server Role Permissions is now supported:
· Permissions of Server Roles for Sybase ASE database is now included with CREATE, ALTER and DROP when using Script to Window on Server Roles and Database Roles Schema Objects.
Sybase ASE User Defined Messages is added in Aqua Data Studio 11.0:
· 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. "sysusermessages" contains one row for each user-defined message that can be returned by Adaptive Server.
Sybase ASE Alias Support:
· Scripting database users will script the aliases for users. Scripting Server Users also script aliases for its database users.
Sybase ASE Database Segment Threshold Support:
· Thresholds now appear within the Schema Node Tree underneath Database Segments.
New datatypes supported for Sybase ASE 15.5:
· Added support for datatypes BIGDATETIME, BIGTIME and TIME in Sybase ASE 1...
|
|
Find us on Google+
