DB Solo Changelog

What's new in DB Solo 4.3

Sep 10, 2014
  • SQLite-related bug fixes

New in DB Solo 4.2.9 (Feb 18, 2014)

  • Bug fixes.

New in DB Solo 4.2.8 (Jan 14, 2014)

  • Bug fixes

New in DB Solo 4.2.7 (Oct 31, 2013)

  • Added support for Vertica.

New in DB Solo 4.2.6 (Jul 3, 2013)

  • Bug fixes.

New in DB Solo 4.2.5 (Jun 4, 2013)

  • Added support for SQL Server 2012.

New in DB Solo 4.2.4 (Feb 19, 2013)

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

New in DB Solo 4.2.3 (Dec 19, 2012)

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

New in DB Solo 4.2.2 (May 29, 2012)

  • 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

New in DB Solo 4.2.1 (Nov 30, 2011)

  • Bug fixes

New in DB Solo 4.2 (Oct 12, 2011)

  • 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

New in DB Solo 4.1.2 (Mar 30, 2011)

  • 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

New in DB Solo 4.1.1 (Feb 16, 2011)

  • Bug fixes

New in DB Solo 4.1 (Feb 8, 2011)

  • 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

New in DB Solo 4.0.2 (Jan 24, 2011)

  • Bugfixes

New in DB Solo 4.0.1 (Jan 20, 2011)

  • Bug fixes

New in DB Solo 4.0 (Jan 18, 2011)

  • Added Server Comparison Tool, which allows you to compare server-level objects (users, roles, databases, tablespaces, etc) between two database servers.
  • Added Server Scripting Tool
  • Added PostgreSQL Function Editor
  • 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
  • Added Support for PostgreSQL 9

New in DB Solo 4.0.1 Beta 1 (Oct 13, 2010)

  • 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

New in DB Solo 3.8.2 (Jun 8, 2010)

  • Bug fixes

New in DB Solo 3.8.1 (Mar 31, 2010)

  • 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

New in DB Solo 3.7.5 (Sep 1, 2009)

  • Support for displaying the Sybase ASE execution plan was added.
  • The schema compare tool was enhanced to optionally compare privileges granted to objects.
  • Support for SQL*Loader scripts was added in the data compare tool.

New in DB Solo 3.7.3 (Apr 28, 2009)

  • 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

New in DB Solo 3.7.2 (Mar 17, 2009)

  • Support for PostgreSQL user management was added.

New in DB Solo 3.7 (Feb 10, 2009)

  • A result set comparison feature was added that allows one to compare two result sets and quickly identify differences between them.
  • The Query Editor and Export Tool now supports XML and Excel output formats.
  • Support for custom key bindings was added. Support for SQL Server Agent was added, including configuration for Jobs, Alerts, and Operators.

New in DB Solo 3.7 Beta (Jan 6, 2009)

  • A result set comparison feature was added that allows one to compare two result sets and quickly identify differences between them.
  • The Query Editor and Export Tool now supports XML and Excel output formats.
  • Support for custom key bindings was added.
  • Support for SQL Server Agent was added, including configuration for Jobs, Alerts, and Operators.

New in DB Solo 3.5 (Sep 9, 2008)

  • Stored procedure editors for MS SQL Server and Sybase were added as well as a stored procedure editor and debugger for Oracle.
  • Numerous enhancements to the schema and data compare tools were also added.