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.
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 EnvironmentsDB Solo supports the following operating systems.
Database Object BrowserDatabase 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.
The SQL Query ToolThe 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.
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 DataThe 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.
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 DataDB 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.