dbAnalyst envision easily exploring your databases with graphic representations, creating your own database queries with our query wizard, even being able to modify and expand your databases.
dbAnalyst provides a single interface to a variety of databases.
Imagine visualizing structure and exploring content from one database, transferring structure and content to another database.
Imagine being able to modify and expand on your database, even with only cursory knowledge of the mechanics of your database. dbAnalyst will present database- and version- specific editors for most types of database objects, including tables, views, triggers, procedures, and functions.
Imagine getting database alerts for common database administration issues. Imagine for experienced users getting a single SQL console for all types of databases, including the ability to spool any output to disk, get any SQL execution plan, stop any query at any point, and more.
As experienced by many of our Users, dbAnalyst creates dramatic productivity improvements for database management.
dbAnalyst provides cross-platform database administration services, by providing modules for Oracle8 (8.0.5), Oracle8i (8.1.6), Oracle9i (9.0/9.1, 9.2), Microsoft SQL Server (7/2000), PostgreSQL (7.1/7.2, 7.3), iAnywhere (8.0), Microsoft Access, dBase and MySQL (4.0).
Here are some key features of "dbAnalyst":
Schema Explorer:
· Expert Knowledge at your finger tips
dbAnalyst provides insight, with a common look and feel for all databases, fitting database platform- and version-specific vendor specificities. Features include:
· Explore schemas, understand relationships and dependencies.
· Generate SQL scripts.
· Compare, Translate schemas
· Export, import schema content.
· Manage schema objects
SQL Console:
Life calls for serious tools. The SQL console provides the features needed for DBAs and developers. Features include:
· One console for all database platforms
· Enter SQL commands, with grid or text ouput
· Analyze SQL execution
· Memorize SQL statements
· Full Syntax highlighting
Query Builder:
· The Query Builder is the tool for effortlessly building SQL queries using a wizard driven, intuitive user interface.
· Supported Databases
· Current support includes Oracle, Microsoft SQL Server, PostgreSQL, MySQL, IBM DB2, Microsoft Access, Sybase iAnywhere, Cache, dBase and Text Files. Additional support is planned for Informix, Sybase and Ingres.
Requirements:
· 1GB minimum system RAM, 10MB hard drive minimum space
· Microsoft Data Access Components (MDAC) 2.8
· MSXML 4.0
Limitations:
· Several features are unavailable ('Edit Table,' 'Import,' 'Export')
What's New in This Release: [ read full changelog ]
Changed object script display from static display to dynamic (hot) display of objects:
· support for object navigation,
· support for context sensitive help,
· support for dependency object navigation
· Added navigation to Online Help Form. Added top online help navigation.
· Fixed dependency display, for object having only 'to' dependencies.
· Added HTML tags filtering/stripping for object scripts for script execution.
· Fixed: When executing a bad SQL stmt, the code throws the wrong exception on the next statement / following command because record set is null.
· Fixed object collective display
· Fixed bad character in XML display
· Deleted temporary file used for HTML output when closing Schema Display Form
· Added navigation to Online Help Form. Added top online help navigation.
· Schema Display Form: added support for coloring of HTML Display, HTML anchors
· Oracle10g 10gR2: Added top menu help and context sensitive help
MySQL 5.0:
· Created support for MySQL 5.0, including tables...
Find us on Google+
