DB Solo 2.0.1 Final review

DB Solo program is a powerful yet affordable cross-platform database development and management tool for both developers and DBAs

License: Shareware File size: 0K Developer: DB Solo Team

0

DB Solo program 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 queries. DB Solo supports most major operating systems and DBMS products available today.

Here are some key features of "DB Solo":
Cross-platform database 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 queries in the query window that supports
Auto completion
Syntax coloring
Explain Pla
Persisted query history
Multiple result sets
Script Generator
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 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 and XP
RedHat Linux
Solaris

DB Solo supports the following database platforms.

Oracle 9, 9i and 10g
SQL Server 2000
Sybase ASE
MySQL 3.23, 4.x and 5.0
DB2 UDB 8.x
Solid EmbeddedEngine™ and Solid BoostEngine™

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

Query Tool

The query window allows you to enter and execute 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.

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.

Limitations:
30-day trial

What's New in This Release:
Support for PostgreSQL schema comparison has been added, which will report any discrepancies between schemas such as missing or mismatching stored procedures, tables, columns, indexes, constraints, as well as column discrepancies such as data type, nullability, and defaults.