DB Solo 3.7.5

DB Solo 3.7.5 will make you satisfied because it is designed as 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.

Major Features:

1. Interoperable
   • 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.
2. 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 the prices and features with competing products, by choosing DB Solo you simply can't go wrong.
3. 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.
4. The SQL Query Tool
   • The 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.
5. 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.
6. 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.
7. 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.
8. 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.

 Enhancements:

• Support for custom key bindings was added
• Query Editor now supports result set comparisons. Compare two result sets and quickly identify differences between them. You can also save result sets for later comparisons.
• Query Editor and Export Tool now support XML and Excel output formats
• Query Editor supports substitution variables, allowing one to write parametrized queries
• Added support for SQL Server Agent, including configuration for Jobs, Alerts and Operators
• MySQL JDBC driver is now bundled with DB Solo
• Much more.

Requirements:

• Support the following operating systems.
• • Mac OS X
  • Microsoft Windows NT, 2000, XP and Vista
  • RedHat & Ubuntu Linux
  • Solaris
• Support the following database platforms.
• • Oracle 8.1.7, 9, 9i, 10g and 11g
  • SQL Server 2000 and 2005
  • Sybase ASE 12.5 and 15
  • MySQL 3.23, 4.x and 5.0
  • DB2 UDB 8.x and 9.x
  • Solid EmbeddedEngine™ and Solid BoostEngine™
  • PostgreSQL 7.3 and later
  • H2