DB Solo Short Description:
Database development and management tool for developers and administrators
DB Solo Long Description:
DB Solo is a powerful database development and management tool for developers
and DBAs. 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 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.
You can 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.