DB Cruiser: Features & Benefits
Overview:
The unique query-oriented approach allows you to build SQL queries at almost any place. Specially, you can start build a 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:
- • Maintain multiple concurrent connections to different databases.
- Report functionality
- o Generation of 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 active database connections via DB Cruiser:
- Who is connected; when the connection was last used, and what databases they connected to.
- Disconnect any unwanted active 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 simply 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
- Slightly modify an existing connection
- 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 in a 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 overridden 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
