DB Solo - The SQL Query Tool is a powerful yet affordable cross-platform database development and management tool for both developers and DBAs. With its rich feature set, it is comparable to tools that are orders of magnitude more expensive. DB Solo has an intuitive user interface that allows you to explore and manage your database objects as well as execute your own ad-hoc SQL queries. DB Solo supports most major operating systems and DBMS products available today.

Key Features

Cross-platform SQL Query Tool with support for all major DBMS products
Multiple simultaneous database connections
Browse and manage database structures with a couple of mouse clicks
Create and drop common database objects using the advanced DBA features.
Enter ad-hoc SQL queries in the query window that supports
Auto completion
Syntax coloring
Explain Plan
Persisted query history
Multiple result sets
Schema Scripting Tool
SQL Data Import Tool
SQL Export Tool
Oracle Stored Procedure Editor and Debugger
Stored Procedure Editors for Sybase and SQL Server
J2EE Code Generator for POJOs, EJB 3.0 annotations, JDBC persistence layer using the DAO pattern, JUnit tests, etc.
Schema Comparison Tool - Including Schema Synchronization
Table Data Comparison And Synchronization Tool
Database Search Tool
View table references in a graph or list format
View rows related to a selected table row
View images stored in BLOB columns (GIF, JPG and PNG)
View ASN.1 and XML data in a tree format
Store favorite queries and database objects

Interoperable

DB Solo supports most major relational database products available today including Oracle, Microsoft SQL Server, Sybase, DB2, Solid, PostgreSQL, H2 and MySQL. You can manage all of these DBMS products -- even at the same time -- from a single application.

DB Solo runs on multiple operating system platforms, so you don't have to buy another tool only because you want to run manage your databases from different operating systems. Since DB Solo is written in Java, it provides the same user experience on all supported operating system platforms.

DB Solo also supports Japanese, Korean and Chinese character sets in all of its windows, allowing you to view and edit Asian character set-based data in your database. All you have to do is change the display font of DB Solo to one that can display the characters need to use.
Affordable

You would be hard-pressed to find a tool with DB Solo's capabilities anywhere near the price range of DB Solo. Please compare our prices and features with competing products, by choosing DB Solo you simply can't go wrong.

Supported Environments
DB Solo supports the following operating systems.

Mac OS X
Microsoft Windows NT, 2000, XP, Vista, 7 and 8
RedHat & Ubuntu Linux
Solaris

DB Solo supports the following database platforms.

Oracle 8.1.7 and later
SQL Server 2000 and later
Cassandra 2.0 and later
Sybase ASE 12.5 and later
Vertica 6.0 and later
Sybase SQL Anywhere 9 and later
MySQL 3.23 and later
DB2 LUW 8.x and later
Solid EmbeddedEngine™ and Solid BoostEngine™
HSQLDB 2.0 and later
SQLite 3.x
PostgreSQL 7.3 and later
H2

Database Object Browser
Database browser provides a simple but powerful tree view to your database objects. With a couple of mouse-clicks you can drill into your database object hierarchy and see virtually all objects your database contains. In addition to viewing objects such as schemas, tables, indexes, views, tablespaces, users, roles, sessions and stored procedures you can also see data in your tables and views. You don't need to know SQL to be able to navigate and explore your database structures. All database objects are divided into logical folders so you will immediately find what you are looking for. The object browser contains support for the following features.

Multiple simultaneous database connections
View/Create/Drop databases, schemas, tables, views, stored procedures, users, roles, sessions, tablespaces, data files, synonyms, sequences, rules, defaults and user defined data types using the advanced DBA Features.
View/Edit /Create/Delete/Print table data
Export table/view data as CSV or HTML
Create/Drop tables and indexes
Script Generator
View table constraints, indexes, columns and triggers
View table references in a graph or list format
Retrieve all or filtered rows of a table from database and search, sort and export the result set
View images stored in BLOB columns (GIF, JPG and PNG)
View ASN.1 data in a tree format
View XML data in a tree format

The SQL Query Tool
The query window allows you to enter and execute SQL queries manually and view the output from multiple result sets in separate tables. Result tables can dynamically be filtered if you wish to narrow down your query results. In addition to this, all result tables can be sorted, printed and data can be exported from them. Detail window allows you to see details on a selected cell of the result window, such as the actual image stored retrieved from a BLOB column. Query window contains the following features.

Execute one or more SQL queries
Auto completion
Syntax coloring
Explain Plan
Persisted query history
Multiple result sets
Stored procedure creation
Configurable statement separators
Support for server-side comments (hints)
Sort, search and print the query results
Export result sets as CSV or HTML
View images stored in BLOB columns (GIF, JPG and PNG)
View ASN.1 data in a tree format
View XML data in a tree format

Table/Index Creator

Table creator allows you to create new tables by providing an intuitive wizard-based interface. The table creator allows you to define columns and constraints for your table without knowing the exact SQL syntax needed for table creation. It also provides a preview screen where you can see the exact SQL statement that will be executed. If you wish, you can copy the SQL from the preview screen to the Query Tool and modify or save it before sending it to the database server.

Index creator lets you create indexes for your tables with a couple of mouse-clicks just like the table creator lets you create tables. Supports several DMBS vendor-specific features such as bitmap indexes for Oracle and Fill Factor for MS SQL Server. You can view/save the generated SQL in the preview window.

Edit/Create/Drop Table Data
The database object browser not only allows you to view table data without knowing SQL, you can also edit the data in-place by double-clicking on a cell and typing in the new value. You can also create new rows in your table or delete existing rows without typing in any SQL statements. You can insert values into BLOB/CLOB columns either manually or store the contents of a file system file.
Favorites

You can add your favorite queries, tables, views and other database objects to your Favorites list, just like you would in your Web Browser. By selecting an item from the Favorites-menu you can immediately bring up frequently used database objects in the browser tree or queries in the query panel. This time-saving feature also allows you to organize your favorites using folders in a tree-like hierarchy.

Favorites toolbar allows you to access your favorite database objects and queries even faster. Favorite toolbar is placed under the main toolbar, enabling you to access its contents with a single mouse-click.

Export Table Data
DB Solo allows you to export data from a table or the result set of an ad-hoc query to an external file or system clipboard. The export process is highly customizable allowing you to select rows, columns, column ordering and formats for the output among other things. The preview functionality allows you view the first rows of your customized output before exporting large sets of data.

The supported export formats are CSV and HTML.

Only for V.I.P