|
Features: dbAnalyst
dbAnalyst is an integrated development and management environment with a single consistent interface to all major relational databases.
dbAnalyst is a collection of database management tools and includes:
| |
 1 |
 |
The Database Connection Profiles: Create database connections to your databases by using database-specific, version-specific connection wizards. |
| 2 |
 |
The SQL Query Console tool: The workbench for database administrators and database developers. Create and execute SQL statements using advanced editing functions, advanced display functions, etc.
|
| 3 |
 |
The Schema Explorer tool: Get the big picture. Understand database object relationships, etc.
|
| 4 |
 |
The Query Builder tool: Intuitively build database queries using drag-and-drop actions.
|
| 5 |
 |
The Database Spy tool: capture database access and SQL statement events as they occur.
|
dbAnalyst offers the tools that are most required to develop, analyze and maintain databases. dbAnalyst was designed to rely on database and database-version configuration scripts that enable dbAnalyst to closely match database feature sets; dbAnalyst is enabled to new databases or database versions in a matter of days.
Create and use Database Connection Profiles.
 |
Creating a database connection profile is made possible by stepping through database-specific wizards: Select your target database type, enter required parameters and test your connection. Optionally, additional parameters may be required to enable additional software functions, such as the Database Spy tool. Once created, a connection profile will enable one-click connection to your database.
Target relational databases: For all database environments
|
| Specific Connection Setup wizard by database vendor and version |
 |
|
| Specific Connection Setup wizard by database vendor and version |
|
|
SQL Query Console tool.
 |
The essential tool for database professionals: create and execute SQL statements using syntax highlighting (i.e. display SQL code in different colors and fonts according to the category of terms) and code auto-complete (i.e. predict or suggest a word or phrase that the user wants to type in without the user actually typing it in completely), execute data definition language (DDL) statements or data manipulation language (DDL) SQL statements, and view result sets in text or grid format.
Target relational databases: For all database environments
|
| Execute DDL or DML SQL statements |
|
|
| View result sets in grid or text format |
Grid |
Grid, Text |
| Syntax colored SQL editor |
|
|
| Store and recall editor SQL scripts |
|
|
| Remember recently used script files |
|
|
| Code auto-complete (i.e. Intellisense) |
|
|
| Execute current statement at cursor |
|
|
| Execute multiple selected statements |
|
|
| Show current editor line in different background color |
|
|
| Show current statement using editor gutter display |
|
|
| Support for multiple SQL Query Console windows |
|
|
| Execution control (stop on error/warning) |
|
|
| Editable result sets in grid format |
|
|
| Support for BLOB, CLOB and binary data |
|
|
| Maintain a running SQL statement log |
|
|
| Save SQL statements session after sessions |
|
|
| Create favorite SQL statements |
|
|
| Export result sets to file or clipboard as CSV, Tab, XML, HTML XML or insert statements. |
CSV, HTML |
CSV, Tab, XML, HTML XML or insert |
| Manage transactions (commit, rollback or auto-commit) |
|
|
| Spool statements and result sets to file |
|
|
| Grid: Sort by clicking column header |
|
|
| Stop execution of SQL statements |
|
|
| Produce Statement Execution plan |
|
|
| Display statement structure |
|
|
| Analyze statement and Suggest Indexes |
|
|
Schema Explorer tool.
 |
The Schema Explorer tool is the gateway to a quick and convenient global understanding of your database schema: visualize database objects in context, understand relationships and dependencies.
The schema explorer displays database objects with ease of use, and a common look & feel for all databases. Database platform- and version-specific display, intuitive object editors and wizards allow you to manage your database objects, including tables, constraints, indexes, views, etc. Major features include:
- List database schemas. Explore schemas, list and view objects including structure (script), visualize and understand relationships , view dependencies.
- Create and manage objects using intuitive wizards
- Generate object scripts (create, drop, delete, etc)
- Compare schema to schema, within or across database vendors.
- Translate schemas from database vendor to another database vendor.
- Export and import content and structures either in database-agnostic binary format, in text or in XML format
Target relational databases: For all database environments
|
| Show schema/schema proxy list |
|
|
| Show schema object hierarchy |
|
|
| Show Objects including tables, indexes, views, triggers, stored procedures, etc. |
|
|
| Show object Create, Drop, Delete scripts |
|
|
| Show object parent and child dependencies |
|
|
| Show schema object graph |
|
|
| View object content in SQL Query Console |
|
|
| Search database objects |
|
|
| Refresh schema structure from database as needed |
|
|
| Show Object database meta data |
|
|
| Show object data in grid format |
|
|
| Process and Show Object custom alerts |
|
|
| Create objects |
|
|
| Edit objects |
|
|
| Drop Objects |
|
|
| Create schema snapshot |
|
|
| Compare schemas |
|
|
| Translate schema to another RDBMS |
|
|
| Export object content to file or clipboard as CSV, Tab, XML, HTML XML or insert statements |
CSV, HTML |
CSV, Tab, XML, HTML XML or insert |
| Export schema object structure & content to database-agnostic binary format data files |
|
|
| Import structure & content in schema from database-agnostic binary format data files |
|
|
Query Builder tool.
 |
Effortlessly build database queries using intuitive wizards. Select objects to query, let the wizard create object relationships and gather query result in grid format.
Target relational databases: For all database environments
|
| Use wizard to select tables, columns and create table relationships. |
|
|
| View tables and table relationships as a diagram |
|
|
| View database query result in grid format |
|
|
| Drag and Drop columns from table diagram to grid to expand query result set |
|
|
| Click on column headers to order result set |
|
|
| Edit table content by modifying grid cells |
|
|
| Edit wizard SQL query in text format |
|
|
Database Spy tool.
 |
The Database Spy tool captures application performance data with minimum database environment impact, and provides high level issue highlighting as occurring - in minutes instead of days. The Database Spy tool captures user database access and SQL statement events as occurring. Event capture occurs on demand during any user session, or automatically when user sessions are established. Each captured event consists of a SQL statement, parameters, statement execution plan and potential execution issues. The Database Spy tool exhibits the root cause to statement execution poor performance as well as the means and metrics to address such issues - such as missing indexes, Disk IO issues, awkward SQL statements, etc.
Target relational databases:For Oracle 10g and Microsoft SQL Server 2005
|
| List active user sessions, including session ID, logon date, client host, schema and application. |
|
|
| List user database trace files |
|
|
| Refresh active user session list and database trace files |
|
|
| Sort session list by grid header |
|
|
| Select a session: start and stop capturing SQL statement events for that session. |
|
|
| Trigger automatic capture of SQL statement events for any schema |
|
|
| Select a list: list session SQL statement events |
|
|
| Select a session SQL statement events: display event SQL statement, parameters, statement execution plan and potential highlighted execution issues |
|
|
|
