dbRadar 1.4 review
DownloaddbRadar is a tool for the administration, monitoring and development of a variety of Databases.
|
|
dbRadar is a tool for the administration, monitoring and development of a variety of Databases.
dbRadar works with the following databases:
• Oracle
• PostgreSql
• MySql
• DB2
• ODBC
• SqlLite
If the connection is successful the worksheet will open and the user can then use any DDL or DML that the target database supports. dbRadar uses the MDI approach for representing all of its child windows. This means that the user can open as many windows as he/she wants, close and navigate through them. From the File menu the user can Print, Save and Load any text files into the worksheet and execute them as sql scripts. The user can drop the actual connection with the database and start a new one from the File menu.
In the worksheet the user can cut, copy and paste any text using the appropriate key (CTRL-X, CTRL-C, CTRL-V) combination or by choosing the edit menu after the text has selected. The Database menu offers the user the ability to open a new worksheet or a new system load window. To switch from one window to another, use the Window menu. For Oracle and PostgreSql connections the user has the ability to use code completion for selecting columns from the tables. The user can save the result set by right clicking the mouse over the grid and choosing a name for the file.
For Oracle connections only, the user can browse the objects from the database using the tree representation from the left and also can choose to see the execution path for a specific select statement by clicking the explain button from the worksheet toolbar.
Here are some key features of "dbRadar":
Worksheet - Issue any DDL or DML that is supported by the target database. The result set is presented in a grid from which it can also be saved. A status display will indicate the progress of the query.
Threaded Queries - Queries run in their own thread so that the application remains responsive even during long executions. A special feature for Oracle databases is the ability to break any long running query.
Multiple, simultaneous database connections. The user can switch from one connection to another.
Powerfull editor with Syntax highlighting for : SQL, PL/SQL, PGPL/SQL, MYSQL, DB2
Code completion - Makes it quick and easy to select columns you want from your particular database. This feature is only available for Oracle and PostgreSQL currently.
Oracle Applications - Only for Oracle Business Suite 11.0.3 and 11.5. You can monitor OA users and kill sessions. An upcoming version will allow you to view concurrent requests.
Remote Info - Gather remote/local HP-UX, Sun OS, Linux load (system, user, idle) and processes.
Database Objects - Users can visually browse and edit database objects (Oracle only).
Save/Load any text files and execute them as SQL scripts, keep history files.
Print any text in a worksheet.
Tuning - The worksheet provides a tabbed page where the user can see the execution path for the current statement executed in a tree fashion (only for Oracle currently)
Supports statements with placeholders in the worksheet. This way a user can insert something like a large object into the database.
Ftp Support. Users can open, edit and transfer files via ftp.
Limitations:
Time limited demo.
dbRadar 1.4 search tags