Aqua Data Studio
SQL Query tool that allows developers to create edit and execute SQL scripts
Click on an image to view a larger version.
Features
- » Aqua Data Studio's Query Analyzer allows users to generate Visual Explain Plans with or without executing the SQL statements. The explain plan may be displayed in both a tree-table view and in diagram view. Visual Explain currently supports Oracle, DB2 and Microsoft SQL Server, providing a common and easy to use interface to all three databases. Visual Explain may be enabled to execute everytime statements or executed, or they may be executed individually with the "Execute Explain" command in the Query Window.
- » Its Visual Editing capabilities allow you to CREATE, ALTER, RESIZE and DROP storage devices for a given database. The schema browser also allows you to navigate the storage structure and to visually alter any of the components of the storage objects and then commit the changes. The visual editing also provides you with an SQL Preview of the SQL which will be used to commit the changes. Storage objects supported include Databases, Tablespaces, Datafiles, Rollback Segments, Redo Logs, Containers and Backup/Dump devices.
- » Its graphical browsing capabilities allow you to browse through all database administration objects and extract the definitions to script the SQL DDL syntax for creating, altering and dropping the storage and security objects (including Databases, Tablespaces, Datafiles, Containers, Users, Groups/Roles and Profiles).
- » Its Import Tool allows you to import any delimited text file into an existing table or into a new table. The import wizard provides you with an easy to use interface that guides you through the import process and provides you with a preview of the data that is to be imported before you commit the data. The Export Tool allows you to export the contents of any table or the results of any SELECT statement. Exported data may be saved in a delimited text file or a file with INSERT statements. Aqua Data Studio also has a context sensitive "Tools" menu in the schema browser popup menu, so a user may browse through the schema to the Table to be exported and then run the Tool. The Tool will use the currently selected Server Connection and the currently select database/schema/table.
English
Supported Technologies
Linux,
Macintosh,
Solaris/Sun OS,
Windows 95/98/ME,
Windows XP/2000/NT
XML
Software
Click on a technology to view similar products within this category.
Pricing
Users (# of seats)
149.00
info@aquafold.com
Resources
Additional Product Information
Aqua Data Studio is a SQL editor and developer tool that allows 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.