Change Log

Notice that the change log only contains new features and enhancements. Each revision also contains bug fixes that are not listed.

3.0.0

• Schema Scripting Tool allows you to create a DDL script for your entire schema
• Import Tool lets you import data from CSV or fixed-length files into a table
• Support for Sybase SQL Anywhere (ASA) was added
• Support for Sybase user management, including the ability to add/modify/drop database users, database roles and server logins
• Support for SQL Server 2000 & 2005 user management, including the ability to add/modify/drop database users, database roles and server logins
• Support for Mac OS 10.5 (Leopard)
• Much more, view the complete list here

2.2.7

• Bug Fixes.

2.2.6

• Bug Fixes.

2.2.5

• Bug Fixes.

2.2.4

• DB2 User Management. Added support for creating, deleting and altering DB2 users and groups. You can modify system privileges, object privileges, schema/database access and other attributes of user accounts.

2.2.3

• Oracle User Management. Added support for creating, deleting and altering Oracle users, roles and profiles. You can modify system privileges, object privileges, roles, quotas and other attributes of user accounts.

2.2.1

• Instead-of triggers. Added support for Oracle, DB2 and SQL Server instead-of triggers on views. The Schema comparison tool also supports these triggers now.
• Oracle Object and Collection types. Support for Oracle object, nested table and varray types was added, including support in the schema comparison tool.
• Database Search. New database search tool was added that allows one to search for a certain string in the database. The searched string can appear in the object (table, view, etc) name or source code of a function/procedure/package/trigger/view.
• Postgres Triggers. Added support for PostgreSQL triggers.

2.2

• Added Table Data Compare Tool. Table data compare tool allows you to compare table rows between tables in different databases and report the differences. The tool can then create a synchronization script that will reconcile the differences.
• Embedded Directory Viewer. The query editor now has an embedded directory viewer that allows you to view your OS files and open scripts in the same query editor.
• Many-to-many Relationships. The J2EE code generator can now generate EJB3 annotations for many-to-many relationships that are use a mapping table.
• Oracle XMLType. The J2EE code generator now supports Oracle's XMLType data types for JDBC access layer and EJB3 annotated Pojos. The generated EJB3 code is Hibernate-specific.

2.1.5

• Colored source diff in Schema Compare. Schema compare tool now uses a color-coded diff output in the detail panel.
• Pinned result sets. The query editor now allows results sets to be pinned so that they are saved when a new queries are executed.

2.1.4

• Sequence support in Schema Compare. Schema compare tool now supports sequences for Oracle and DB2.
• Error line numbers. Error line numbers are shown for Sybase and SQL Server.

2.1.3

• Pacakge support in Schema Compare. Schema compare tool now supports Oracle Packages.
• Embedded Browser Tree. The Query Panel now has an embedded schema browser tree that can be shown/hidden with a single button click.

2.1.2

• MacOS X redesign. UI overhaul for MacOS X was done.
• MySQL Triggers. Added support for Triggers in MySQL
• Schema synchronization script enhancement. The schema synchronization script creator now allows you to specify which objects to include in the output DDL script.

2.1

• Schema Synchronization Scripting. The Schema Comparison Tool was enhanced with the capability to procedure schema synchronization scripts. Based on the detected conflicts between the two compared databases, a database synchronization DDL script can be generated with all necessary ALTER, CREATE and DROP sql statements.
• Command Line Schema Comparison. The Schema Comparison can now be invoked from command line.
• H2 Support. Support for the H2 database was added, including support in the J2EE code generator.
• J2EE Code Generator Enhancements.The JDBC/EJB 3.0 code generator tool now fully supports identity columns for PostgreSQL and MySQL.

2.0.2

• DB 9.x. Added support for IBM DB2 UDB 9.x.
• Results panel enhancement. The detail view of the results panel can now be collapsed.
• Schema compasion enhancements. Procedure source code comparison shows diff-style output.

2.0.1

• PostgreSQL Schema Comparison. The schema comparison tool now supports PostgreSQL.

2.0.0 Final

• Inheritance. J2EE code generator now supports single table and joined inheritance types of the EJB 3.0 / JSR-220 specification.

2.0.0 Beta 4

• JDBC persistence code. J2EE code generator now allows you to create a complete JDBC persistence layer using the DAO pattern. The generated code will include DAO interface, JDBC implementation of the DAO interface as well as a JUnit tests for each generated entity. In addition, a DAO Factory plus the corresponding JDBC implementation will be created. The generated access layer will contain CRUD functionality as well as finder methods for each column/field.

2.0.0 Beta 3

• Embedded Objects. J2EE code generator now allows you to create embedded objects, or components, that you can embed in the generated entities.
• One-to-One mappings.One-to-One mappings are now generated for Hibernate mapping files and EJB 3.0 annotated Pojos when a foreign key owner table has a unique constraint whose columns match the columns of the foreign key.

2.0.0 Beta 2

• JUnit Tests. When Pojos with EJB 3.0 annotations are generated, a JUnit-based test class can optionally be generated for each entity. Each test class will extend the standard JUnit TestCase class and test basic CRUD functionality using the corresponding entity. Also, a Hibernate utility class (HibernateUtil.java) will be created that contains Hibernate-based utility methods.
• Java Pretty-Printer. All generated Java-files are processed by a configurable code beautifier. This allows the generated classes to adhere to the coding conventions of your organization. The Java pretty-printer configuration options allow one to set indentation, spacing, brace handling and much more.

2.0.0 Beta 1

• DB2 Explain Plan. Explain plan support was added for DB2.
• Intel Mac. Added support for Intel-based Mac OS X systems (Universal Binary).
• J2EE Code Generator. Added J2EE code generator that can take your existing schema and generate the following:
  • POJO (Plain Old Java Object) class files
  • POJO class files with EJB 3.0 annotations
• Added support for user-specified JDBC-driver properties.
• Sybase 15 is now supported.
• SQL Server 2005 is now supported.
• Solid 4.5 is now supported.
• SQL Server: Added support for xp_cmdshell stored procedure.
• Postgres: Added support for Users, Groups, Sessions, Tablespaces.
• SQL Server: Current SQL shown for user sessions.
• Sybase: Added support for 'set showplan on' command . When executing a query, the plan is shown in the log panel.
• Oracle: public synonyms are now shown under a separate folder in the browser tree.
• Oracle: Connections can now be made using service names instead of SIDs.
• SQL Server: Added support for the XML data type.

1.3.2

• Added more PostgreSQL features. Added PostgreSQL support in the script creator. You can now view CREATE scipts for your tables, indexes and constraints.
• Added support for DBMS_OUTPUT. View output from your stored procedures that use the DBMS_OUTPUT system package.
• Added support for OCI 10 drivers. New OCI driver supports locally installed Oracle clients, notice that Oracle 9 client will not work. Just enter a service name entry corresponding to an entry in your tnsnames.ora file.

1.3.1

• Added more PostgreSQL features. Added the ability to add/dropp indexes, constraints, columns, and sequences.
• Schema comparison improvements. Schema comparison tool's results can now be viewed and saved as text.
• Oracle function-based indexes. Oracle function-based indexes are now shown correctly.

1.3

• Added support for PostgreSQL. PostgreSQL support is for version 7.3 and later.
• Added support for Oracle 8.1.7.

1.2.5

• Added Support for Generic JDBC Connections. You can now connect to any JDBC-compliant data source by providing a JDBC driver for the data source. To set up a generic connection, you have to point to the jar file, pick the correct driver class and finally enter the connection URL for the data source.

1.2.4

• Added Support for Views and Functions in Schema Comparison Tool. Schema Comparison Tool allows you to compare tables, views, functions and stored procedures between two schemas/databases. It will report any discrepancies between schemas such as missing or mismatching tables, columns, indexes, triggers and constraints. It also will detect column discrepancies such as data type, nullability and defaults. Comparison can also be done between two different DBMS platforms, such as Oracle and SQL Server.

1.2.3

• Added Support for Adding and Dropping Views. You can now drop existing views and create new ones.
• View Definitions. You can now view the select statement(s) that define a view. The browser panel now has a new tab 'Source' available when you click on a view in the browser tree.

1.2.2

• Added Support for Triggers and Stored Procedures in Schema Comparison Tool. Schema Comparison Tool allows you to compare tables and stored procedures between two schemas/databases. It will report any discrepancies between schemas such as missing or mismatching tables, columns, indexes, triggers and constraints. It also will detect column discrepancies such as data type, nullability and defaults. Comparison can also be done between two different DBMS platforms, such as Oracle and SQL Server.
• Added Support for multiple instances on SQL Server. You can now connect to servers running multiple SQL Server instances. You can specify the instance in the host field as host\instance or \\host\instance.

1.2.1

• Added Support for Table Indexes to Schema Comparison Tool. Schema Comparison Tool allows you to compare tables between two schemas/databases. It will report any discrepancies between schemas such as missing or mismatching tables, columns, indexes and constraints. It also will detect column discrepancies such as data type, nullability and defaults. Comparison can also be done between two different DBMS platforms, such as Oracle and SQL Server.
• Added Settings to Schema Comparison Tool. You can now select what attributes will be compared between databases/schemas. You can enable/disable comparison of indexes, constraints and columns and also have control over comparison details for these objects. All comparison settings will be persisted between sessions.
• Control Over User Name and Password Persistence. You don't have to persist users name and/or passwords for server connections anymore unless you want to. Although user names and passwords are encrypted on local disk between sessions, some users may elect not to persist them to achieve higher security level.

1.2.0

• Added Schema Comparison Tool. Schema Comparison Tool allows you to compare tables between two schemas/databases. It will report any discrepancies between schemas such as missing or mismatching tables, columns and constraints. It also will detect column discrepancies such as data type, nullability and defaults. Comparison can also be done between two different DBMS platforms, such as Oracle and SQL Server.

1.0.9

• Added support for adding and dropping constraints. You can now add and drop constraints to/from your existing tables. You can add primary key, foreign key and unique constraints to your tables. Before a constraint is added or dropped, you will have the option to review the SQL command that will be sent to the server.
• Added support for adding and dropping columns. You can now also add columns to your existing tables as well as drop columns from them. Before a column is added/dropped you have the option to view the ALTER TABLE command that will be sent to the server. Notice that DB2 UDB does not support dropping columns.

1.0.8

• Added CREATE TABLE Script Generator for MySQL. Script Generator allows you to produce CREATE TABLE statements based on your existing tables. This allows you take tables in one schema / database, generate the scripts and then create the same tables in a different schema / database. Alternatively you could use the resulting scripts for documentation purposes or check them into your source control system.

  You can select one or more tables from your table list and the script generator will output CREATE TABLE scripts for the selected tables, their constraints and indexes.

• Added support for MySQL procedures and functions. You can now view stored procedures and functions in MySQL 5.0. You can also view the source code for these objects as well as edit it and save the new version of the procedure/function back to the database.
• Added support for sp_ stored procedures in query window. The Query Window now supports sp_ system stored procedures for Sybase and SQL Server. Usually these procedures return multiple result sets that will be shown under their own tabs. Examples of these procedures include sp_help, sp_helpdb, sp_helpconfig, sp_monitorconfig, sp_helpsegment, sp_helpuser, etc.

1.0.7

• Added CREATE TABLE Script Generator for Sybase. Script Generator allows you to produce CREATE TABLE statements based on your existing tables. This allows you take tables in one schema / database, generate the scripts and then create the same tables in a different schema / database. Alternatively you could use the resulting scripts for documentation purposes or check them into your source control system.

  You can select one or more tables from your table list and the script generator will output CREATE TABLE scripts for the selected tables, their constraints and indexes.

• Added support for HTML Export You can now export table/view data as well as result sets of your queries as HTML in addition to the standard CSV export. The data is exported as an HTML table with configurable colors, font sizes and column alignments.

1.0.6

• Added CREATE TABLE Script Generator for DB2. Script Generator allows you to produce CREATE TABLE statements based on your existing tables. This allows you take tables in one schema / database, generate the scripts and then create the same tables in a different schema / database. Alternatively you could use the resulting scripts for documentation purposes or check them into your source control system.

  You can select one or more tables from your table list and the script generator will output CREATE TABLE scripts for the selected tables, their constraints and indexes.

• Added support for index and constraint script generation. You can select one or more constraints or indexes from the index/constraint list and generate the ALTER TABLE scripts corresponding to the selected objects.
• Added support for undo & redo in the query window.

1.0.5

• Added support for Mac OS X. DB Solo on Mac OS X supports two look & feels; JGoodies and Aqua. You can change the look & feel in the Mac OS section of the settings. Notice that Mac OS X 10.4 (Tiger) has a Java bug that affects how buttons and vertical scrollbars are rendered in the default JGoodies look & feel. This bug is not present in 10.3 (Panther).
• Added CREATE TABLE Script Generator for SQL Server. Script Generator allows you to produce CREATE TABLE statements based on your existing tables. This allows you take tables in one schema / database, generate the scripts and then create the same tables in a different schema / database. Alternatively you could use the resulting scripts for documentation purposes or check them into your source control system.

You can select one or more tables from your table list and the script generator will output CREATE TABLE scripts for the selected tables, their constraints and indexes.

1.0.4

• Added CREATE TABLE Script Generator. Script Generator allows you to produce CREATE TABLE statements corresponding to your existing tables. This allows you take tables in one schema / database, generate the scripts and then create the same tables in a different schema / database. Alternatively you could use the resulting scripts for documentation purposes or check them into your source control system.

You can select one or more tables from your table list and the script generator will output CREATE TABLE scripts for the selected tables, their constraints and indexes.

Currently CREATE TABLE script generator is available for Oracle.

1.0.3

• Added support for Solid RDBMS products. DB Solo now supports Solid EmbeddedEngine™ and Solid BoostEngine™. In addition to standard DB Solo features, Solid support includes the ability to CREATE & DROP tables, indexes, sequences, databases. You can graphically browse databases, schemas, tables, constraints, views, triggers, users, roles and view, drop & edit stored procedures. Supported Solid features also include auto-completion and explain plan.

1.0.2

• Graph View for Explain Plan. Explain plan output can now be viewed in as a graph under the 'Plan' tab of the query panel. The graph view provides the same information as the treetable view. Steps of the execution plan are shown as vertices and directional edges represent parent-child relationships. Both graph and treetable views can now be printed, too.
• Explain Plan for SQL Server. Explain plan support has been added for SQL Server in addition to earlier Oracle support.

1.0.1

• Explain Plan. Explain plan is a feature that allows you to view the execution plan of a query in a tree format. When you execute your queries in the query window and the execution plan is available, you can view the plan under the 'Plan' tab. This feature is useful for troubleshooting problems with slow queries, the plan may reveal that the optimizer decided to do use a plan that was unexpected. Currently this feature is supported for Oracle 9.2 and later.

1.0.0

• Identity columns. Identity columns are now supported for SQL Server, Sybase, DB2 and MySQL. When creating a table, you can specify which column(s) will be identity columns. Also, when inserting a new row, you can leave an identity column's value blank and it will not be part of the insert statement.
• Locks. Database locks are now shown for Oracle, SQL Server, Sybase and DB2. Depending on the vendor, you can see information such as session id of the lock holder, lock mode, type of lock and the object/page that is locked.

0.9.8

• Security Object Enchancements. System/object privileges are shown for Oracle users/roles. Database access privilges are shown for SQL Server/Sybase server logins. Authorities are shown for DB2 users and groups.
• Trigger source code. Source code for triggers is now shown.
• Packages and package bodies. You can now view packages and package bodies in Oracle. Viewing and editing package/package body source code is also supported.
• Query Window Statement Separators. Query window now allows you to specify if you want to use a semicolon, 'go' or both as statement separators.
• Query Window Stop on Errors/Warnings. When you have multiple queries in the query window that you want to execute, you can tell query window to stop execution after an error or warning is encountered.

0.9.6

• Explicit Commit/Rollback Control. Instead of using the default auto-commit mode, explicit commit/rollback functionality is now available. This is particularly useful in the query window where one can now run transactions containing several statements and then commit/rollback at the end of the transaction. Setting the transaction isolation level is also supported.
• User-Defined Functions. User-defined functions are now supported for Oracle and SQL Server. You can view a function's source code, edit it in place and save your changes to the database.
• Rollback Segments. One can now view/create/drop rollback segments in Oracle.

0.9.3

• XML Viewer. The detail panel of the Query Window allows you to view XML data in a tree format as well as text format. The XML data can be in any string type column, CLOB column or Oracle XMLType column.
• ASN.1 Viewer. The detail panel can also show ASN.1 data in a tree format . The ASN.1 data can be stored in a BLOB or VARCHAR/CLOB column as base64 encoded string. Data can also be a PEM encoded string.
• DB2 Type 2 JDBC Driver. This new driver type allows you to use your local native DB2 client settings to connect to the server, you don't need to set the host, port, user name, etc. attributes.
• Oracle XMLType. You can now view/update/insert XMLType columns in Oracle.

0.9.1

• DB2 Support. DB Solo now supports IBM's DB2, including support for table spaces, sessions, buffer pools, sequences, aliases, user defined types plus all the standard DB Solo features.
• Edit Stored Procedures. The stored procedure source panel of the browser tree now contains a new Edit button that allows you to edit your stored procedures and save your changes to the database.
• USE <database> statement. Query panel now accepts the USE <database> statement for SQL Server, Sybase and MySQL. Using this feature you can override the database currently selected in the database combo box, all statements after the USE-statement will be executed in the specified database.

0.8.9

• Auto-Completion. Query window can now automatically complete your SQL statements as you type them in. E.g. you can type in 'SELECT * FROM ' and the query window will automatically pop up a window containing tables/view/synonyms available in the current context. Supported statements include SELECT, UPDATE, INSERT, DELETE, etc.
• Windows Authentication for SQL Server. You can now connect to MS SQL Server from any platform even when the server is configured to only use Windows authentication.
• Favorites Toolbar. Favorites Toolbar contains all your favorite database objects and queries right under the main toolbar, providing you an easy access to your objects with a single mouse-click.

0.8.8

• Favorites. You can now add frequently used queries, tables, views and other objects to your favorites list. There is a new 'Favorites' menu that contains all the favorite objects you have added. You can create folders to store your favorites in logical categories to ease finding and managing entries. Favorites management window allows you to edit, create and edit entries and folders on your favorties list, just like your Web Browser does.
• Database Creator. You can create and drop databases on MySQL, SQL Server and Sybase servers.
• Execute Current. If you have multiple SQL statements in the query window, and you only want to execute the query under the cursor, you can do that by hitting the F5 key.
• Help. HTML-based help has been included in the DB Solo package. You can access the help from the Help-menu.

0.8.6

• Selection summary. You can now view statistics on selected cells in result set windows. For example, by selecting multiple numeric cells you can immediately see statistics such as MIN, MAX and AVG.
• Index Creator. Create indexes for your tables with a couple of mouse clicks without knowing the exact SQL syntax. Supports DBMS vendor-specific features such as bitmap indexes for Oracle and Fill Factor for Sybase & MS SQL Server. Also added support for dropping indexes.
• DBA Features. Numerous management features added for DBAs and advanced users.
• Oracle: Control Files & Control File Record Sections [View]
• Oracle: Synonyms [Create, Drop]
• Oracle: Sequences [Create, Drop]
• Oracle: Tablespaces [Create, Drop]
• Oracle: Redo Log Groups / Members [Create, Drop, View]
• SQL Server & Sybase: User Defined Data Types [View, Create, Drop]
• SQL Server & Sybase: Rules [View, Create, Drop]
• SQL Server & Sybase: Defaults [View, Create, Drop]
• SQL Server: Filegroups [Create, Drop]
• Sybase: Database Devices [Create, Drop]

0.8.4

• Solaris support
• Table reference graph
• Parent-child row viewer