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

DB Solo 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.

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

DB Solo runs on Windows, Mac OS X, Solaris and Linux platforms, so you don't have to buy another tool only because you want to run manage your databases from different operating systems.

In addition to viewing and managing objects such as schemas, tables, indexes, views, tablespaces, users, roles , sessions and stored procedures you can also view, edit, print and export data of tables or results of your ad-hoc queries.

With DB Solo you may also graphically view your table's foreign-key relationships with other tables.

You don't need to know SQL to be able to navigate and explore your database structures.

Ad-hoc queries can be entered in a query window that supports auto-completion, explain plan, multiple result-sets, printing, persisted query history, exporting, image, XML, ASN.1 viewing and searching within results.

DB Solo also contains table and index creator tools that allow you to create tables
and indexes without knowing SQL. The table creator allows you to define table columns
and constraints using a simple interface and you can preview the SQL before
the table is created.

J2EE Code Generator tool allows you to generate EJB 3.0 annotated Pojos as well as JDBC DAO access layer code from existing tables.

Schema comparison tool lets you compare two schemas/databases for differences in table definitions, views, functions and stored procedures.

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 Plan
· Persisted query history
· Multiple result sets
· Script Generator
· Schema Comparison 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


Limitations:

· 30 days trial