View Image

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.