DB Solo 4.3
- LICENSE TYPE:
- OUR RATING:
- DEVELOPED BY:
- DB Solo
- USER RATING:
- ROOT \ Database \ Database APIs
Features at a glance
Key features include support for multiple simultaneous database connections, support for all major DBMS (Database management systems) products, a schema scripting tool, the ability to browse and manage database structures with a few mouse clicks, a SQL data import tool, a SQL export tool, a database table data synchronization and comparison tool, as well as the ability to drop and create common database objects via advanced DBA features.
Additionally, the software comes with an editor and debugger tool for Oracle Stored Procedures, a database search tool, stored procedure editors for SQL server and Sybase, a database schema comparison tool that includes schema synchronization capabilities, as well as a J2EE code generator for POJOs, JUnit tests, a JDBC persistence layer that uses the DAO pattern, and EJB 3.0 annotations.
Supports ad-hoc SQL queries
Another interesting feature is the built-in support for ad-hoc SQL queries, which can be entered in the query window, supporting autocomplete, multiple result sets, explain plan, syntax coloring and persisted query history.
With DB Solo you can view table references in a list or graph format, view XML and ASN.1 data in a tree format, view rows related to a highlighted table row, view JPG, PNG or GIF images stored in BLOB (Binary large object) columns, as wel as to store database objects and frequently used queries.
Supported operating systems
Being written entirely in the Java programming language, DB Solo is a platform-indepenent application that has been successfully tested under the GNU/Linux, BSD, Solaris, Microsoft Windows and Mac OS X operating systems. It runs well on both 64-bit and 32-bit hardware platforms.
DB Solo was reviewed by Marius Nestor, last updated on September 10th, 2014