DB Solo

DB Solo program is a cross-platform, commercial and powerful software project that allows Java developers to create and manage databases with a minimal effort as possible. It is designed to be used by both programmers and database administrators (DBAs). It features a user-friendly interface that enables you to easily manage and explore database objects, as well as to run their own ad-hoc queries.

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.

What is new in this release:

• SQLite-related bug fixes

What is new in version 4.2.9:

• Bug fixes.

What is new in version 4.2.8:

• Bug fixes

What is new in version 4.2.7:

• Added support for Vertica.

What is new in version 4.2.6:

• Bug fixes.

What is new in version 4.2.5:

• Added support for SQL Server 2012.

What is new in version 4.2.4:

• Result Set Comparisons can now be run from the command-line.

What is new in version 4.2.3:

• Added support for MacOS 10.8
• Added support for MySQL Geometry data types

What is new in version 4.2.2:

• Columns in the Data Compare Tool can be wrapped inside a SQL function.
• Added the ability in the Schema Compare Tool to only compare indexes with names that match a regular expression
• Added support for Oracle invisible indexes

Limitations:

• 30-day evaluation trial