DB Cruiser: Features & Benefits
Overview:
The unique query oriented approach allows you to build SQL queries at almost any place. Especially, you can start build query visually as soon as you view the table column definitions - no SQL to write [screen].
Furthermore, for each result set, you can view the SQL which produced the result, then modify and re-execute it right at the spot!
Highlights:
- Multiple concurrent connections to different databases.
- Report functionality
- Generate ad hoc reports in HTML, EXCEL® and PDF .
- Eesy to use report formatter. [screen]
- Administration Console (web based) [screen]
- Add, delete, modify, enable/disable connections on the dropdown list.
- Monitor all the acitve database connections via DB Cruiser:
- Who are connected; when they first connected, when they were last used, and what databases they connect to.
- Disconnect any unwanted acitve connections.
- Change debug level and other server parameters at runtime without restarting the servlet container.
- View server status, like memory usage, classpath, etc.
- Import and export DB Cruiser configuration
- View server logs online
- CLOB/BLOB (TEXT/BINARY) handling [screen]
- View the content of CLOB up to maximum allowed size (configurable).
- Download the whole content of CLOB and BLOB.
- Modify/update the content of CLOB by typing.
- Replace the content of BLOB by uploading
- Open style login There are 3 way to connect to a database via DB Cruiser:
- Select an existing connection from the dropdown list
- Modify an existing connection slightly
- Build a connection URL based on the database product and the JDBC driver.
- Tables/Objects Explorer (search tables, system tables, views, synonyms, etc.) [screen]
- Search tables by patterns, similar to LIKE statements in SQL.
- May open tables in new windows so you can do side-by-side comparison.
- Memorize tables visited so you may revisit them without re-searching.
- Query Builder.
- Tables Work Area
- View column definitions, and start build queries without SQL.
- View table size, primary/foreign keys, indexes, DDL, privileges, etc.
- Insert new tables row without SQL, including CLOB/BLOB columns.
- Retrieve last query result for the table.
- Execute SQL statements.
- Query results
- View the SQL which produced the result, may modify and execute it again.
- Modify the data in the result like spreadsheet style - no SQL to write.
- Export the result to HTML, PDF, EXCEL®, CSV, XML, TEXT, or INSERT statements
- Change the display size (per page) and font size while viewing the result.
- All query results are cached - you can view them at later time until they are overriden or deleted.
- Foreign Keys [screen]
- Expose both parent and child keys
- Navigate tables among parent/child keys relationship.
- SQL Editor (SQL Work Area, SQL Work Sheet)
- Execute any standard SQL statements. [screen]
- Execute multiple SQL statements simultaneously. [screen]
- Show all the SQL statements executed in the session
