Change Log

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

5.3.5

• Added support for Oracle hints in Data Compare Tool
• Primary key columns are indicated in the HTML report in Data Compare Tool

5.3.2

• Added support for Postgres 15
• Fixed CREATE INDEX scripting for MySQL text and blob columns

5.3.1

• Added support for Azure SQL Database

5.3

• Added support for MySQL 8

5.2.5

• Added a new Data Search Tool
• DB2 BLOB/CLOB columns are scripted correctly
• Schema Compare Tool: Trigger enabled/disabled flag can be compared
• Data Comparison start/end time shown in the HTML report and sync script
• Data Comparison summary shown on the results page
• Data Compare Tool: Postgres json columns handled correctly

5.2.4

• Data Compare Tool: Added support for Postgres geometry type
• Data Compare Tool: Allow primary key columns in different order between source and destination
• Data Compare Tool: Easier to include a subset of all tables/views
• MySQL: FULLTEXT indexes correctly scripted
• Import Tool: Postgres enum types imported correctly
• Added Support for Postgres 11
• Table reference graph now shows ON DELETE/UPDATE rules for Postgres
• Schema Compare Tool can now compare WITH/WITHOUT OIDS for Postgres
• Add Trigger functionality supported for Postgres

5.2.3

• Bug fixes

5.2.2

• Added support for Postgres 10
• Added support for Postgres enums
• Server group information is now included when importing/exporting connections
• Added support for SQL*Plus spool command

5.2.1

• Added support for Postgres 9.6
• Oracle RAW data type length is checked in the Schema Comparison Tool
• Fixed an issue in the Data Compare Tool with SQL Server datetime2 column data type
• SQL export of Vertica timestamps now works correctly
• Fixed issues with scripting DB2 object permissions

5.2

• Added a data extraction tool that can extract all related rows in parent/child tables
• Schema Comparison Tool can now compare DB2 index clustering
• Data Compare Tool SQL script creator can insert a commit after every N statements
• Added support for SQL Server extended properties
• Bug fixes

5.1

• Added support for Cassandra
• Bug fixes

5.0.3

• Added support for SQL Server nokey index columns

5.0.2

• Bug fixes

5.0.1

• Several Vertica-related bugs were fixed

5.0

• Added support for Java 1.8 on Linux

5.0 Beta 4

• Individual records can be selected for sync script for file-based comparison in the Data Compare Tool
• The schema scripting tools allows one to select objects for based on the name of their schema using regular expressions (SQL Server).
• SQL Server nonkey index columns are scripted correctly in the Schema Compare Tool as well as the Schema Scripting Tool.

5.0 Beta 3

• Added support for Mac OS X Yosemite

5.0 Beta 2

• DB2 index schema can now be compared in the Schema Compare Tool
• Added an option for server connections to persist the default schema/database to be shown in Query Editor
• Support for SQL Server 2014 was added
• Support for Postgres 9.4 was added
• Data type change from Oracle VARCHAR2 to CLOB is now scripted correctly in the Schema Compare Tool
• Nanoseconds can now be optionally shown when timestamp-datatype is displayed

5.0 Beta 1

• New Features
  • Support for Oracle 12c was added
  • Support for DB2 nicknames was added
  • SQL Server 2012 sequences was added
  • Support for DB2 roles was added
  • Support for PostgreSQL view triggers (instead-of-triggers) was added
  • Oracle connections can be created using TNSNAMES descriptors
  • Support for DB2 LUW 10.x was added
  • Support for solidDB 7.x was added
  • Support for Postgres 9.3 was added
  • Oracle NLS parameters can be specified in settings
• Schema Compare Tool
  • Tool now supports comparing against saved snapshots of databases/schemas (offline schema comparison)
  • Newline (Win/Unix) option for SQL sync script was added
  • Postgres partial index constraint is now compared
  • Postgres exclusion constraints are now compared
  • Postgres timestamp precision is now compared
  • Precision is now compared for MySQL temporal data types (TIME, DATETIME, TIMESTAMP)
• Data Compare Tool
  • Multiple records can be selected in the results table
  • Option not to include matching tables on the main page of HTML reports was added
• Schema Scripting Tool
  • Postgres partial index constraint is now scripted
  • Postgres exclusion constraints are now scripted correctly
  • Precision is now scripted for MySQL temporal data types (TIME, DATETIME, TIMESTAMP)
• Schema Browser
  • Self-references (foreign key to the same table) are now shown in the table references tab
  • Database can be added as a favorite object
  • Postgres partial index constraint is now shown in index panel
• Other
  • Dozens of bugs were fixed

4.3

• SQLite-related bug fixes

4.2.9

• Bug fixes

4.2.8

• Bug fixes

4.2.7

• Added support for Vertica

4.2.6

• Bug fixes

4.2.5

• Added support for SQL Server 2012

4.2.4

• Result Set Comparisons can now be run from the command line

4.2.3

• Added support for MacOS 10.8
• Added support for MySQL Geometry data types

4.2.2

• Columns in the Data Compare Tool can be wrapped inside a SQL function.
• Added the ability in the Schema Compare Tool to only compare indexes with names that match a regular expression
• Added support for Oracle invisible indexes

4.2.1

• Bug fixes

4.2

• Added support for SQLite, including support in the Schema Comparison and Data Comparison Tools
• Added Explain Plan support for PostgreSQL
• Added support for DB2 Partitions
• CSV export now has the capability to escape quote characters
• Schema comparison tool can now compare Postgres sequence OWNED BY values
• Postgres 8.2 and later sequence OWNED BY is now scripted correctly
• Postgres foreign key DEFERRABILITY is now scripted correctly
• Added support for PostgreSQL arrays in the Data Compare Tool
• Table triggers are shown under a separate item under schema/database in the Schema Browser

4.1.2

• Schema Compare Tool has an option to ignore the case and quotes in the name of an Oracle function, procedure, package, collection type and object type
• Schema Compare Tool has an option to reduce memory consumption by discarding matching results for functions, procedures, packages, collection types and object types
• Schema Compare Tool results are now available also in XML and HTML formats
• Added support for selecting the file encoding for Data Compare Tool's sync script
• Added support for killing multiple sessions at the same time

4.1.1

• Bug fixes

4.1

• Added support for HSQLDB, including support in the Schema Comparison and Data Comparison Tools
• Schema Compare Tool's sync scripting now supports custom wrappers for identifiers
• Schema Compare Tool's sync scripting now supports the DELIMITER statement for MySQL
• Schema Scripting Tool now supports custom wrappers for identifiers
• MySQL signed vs. unsigned is now compared in the Schema Compare Tool
• Schema Compare Tool's text results now has an option to hide detailed source code differences

4.0.2

• Bug fixes

4.0.1

• Bug fixes

4.0

• Added support for Oracle database links in the Schema Browser as well as Schema Comparison and Schema Scripting Tools
• Added support for Oracle public database links in the Schema Browser as well as Server Comparison and Server Scripting Tools
• Support for PostgreSQL 9 was added

4.0 Beta 2

• Support for DB2 was added in the Server Comparison and Server Scripting Tools
• An installer for 64-bit Windows was added

4.0 Beta 1

• New Features
  • Added Server Comparison Tool, which allows you to compare server-level objects (users, roles, databases, tablespaces, etc) between two database servers. This feature is currently supported for Oracle, MS SQL Server, Postgres and Sybase ASE.
  • Added a Server Scripting Tool
  • Added a procedure editor for Postgres
  • Added the ability to export and import Server Connections from one DB Solo installation to another
  • Added a folder compare tool that allows you to compare and sync files between two folders on your hard-drive
  • Added Support for Windows 7
• Query Editor
  • Added a column view panel, which allows one to view the selected row's values in a vertical table
  • You can right-click on the server connection drop-down and connect/disconnect the selected connection
• Explain Plan
  • The plan graph can now be saved in various formats including SVG, VML, HTML, JPEG, etc.
  • Added a new Table-view that allows you to filter and sort the individual steps
  • Added 'Operator Cost' and 'Operartor Cost %' columns for SQL Server in the tree view
  • The Graph-view now shows 'Cost %' in each node
  • The node with the highest cost is colored red
• Schema Browser
  • Added support for Server Groups. This allows you to organize your Server Connections in folders, e.g. 'PRODUCTION', 'QA', etc.
  • The table reference graph can now be saved in various formats including SVG, VML, HTML, JPEG, etc.
  • Added support for Oracle queues and queue tables
  • Added support for Oracle directories
  • Added support for SQL Server linked servers
  • Added support for viewing and editing table & column comments for SQL Server
  • The Data-tab issues updates with the NOWAIT option for Oracle
  • Added support for SQL Server 2008 data type DATETIME2
  • Added support for MySQL table partitions
  • Added support for DB2 functions
  • Added support for advanced options in the Table Creator for DB2, Oracle, MS SQL Server, Postgres, Sybase SQL Anywhere and MySQL
  • Added support for SQL Server computed columns
• Schema Compare
  • SQL Server table and column comments can now be compared
  • Sync script creator can now optionally include the schema names for DB2
  • Added support for Oracle queues and queue tables
  • Added support for MySQL table partitions
  • Added a setting for ignoring whitespace when comparing check constraint definition
  • Added support for comparing DB2 tables' data/index tablespace
  • Added support for comparing DB2 functions
  • Differences in source code can now be viewed in a separate dialog
  • Source code difference panel now supports synchronous scrolling
• Schema Scripting Tool
  • SQL Server table and column comments are now scripted
  • The script can now optionally include the schema names for DB2
  • Added support for SQL Server 2008 data type DATETIME2
  • Added support for MySQL table partitions
  • Added support for Oracle queues and queue tables
  • Added support for DB2 functions
  • Added support for SQL Server computed columns
• Data Compare Tool
  • The sync script can now be generated for either side
  • The tool can now create a separate sync script file for each table
  • Added the ability to treat empty strings as NULLs
  • Sync script can now optionally turn IDENTITY_INSERT ON for tables with identity columns [SQL Server]
  • Added Select/Deselect All buttons under Extra/Missing/Different tabs on the results page
• User Management
  • Added 'Create Like' option to clone users for Oracle, DB2, Sybase ASE, MySQL, SQL Server and Postgres

3.8.2

• Bug fixes

3.8.1

• Data Compare tool can now select unique constraint columns automatically when no PK is present.
• Added 'OS User' column to the Oracle sessions view.
• Bug fixes

3.8

• Support for MacOS 10.6 (Snow Leopard) was added
• Added support for batch-compiling invalid Oracle objects (functions, procedures, etc)
• Added the ability to find all empty tables within a schema/database
• Added the ability to find table columns that only contains NULLs

3.7.0

• 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
• View the complete list here

3.5.0

• Oracle Stored Procedure Editor & Debugger was added
• Stored Procedure Editor was added for SQL Server
• Stored Procedure Editor was added for Sybase ASE
• Export tool was added which allows you to export unlimited number of rows to a CSV, HTML or SQL file
• Added support for Oracle 11g
• Added support for SQL Server 2008
• Much more, view the complete list here

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