DB Solo Changelog

What's new in DB Solo 5.3.5

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

New in DB Solo 5.3.2 (Jan 29, 2023)

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

New in DB Solo 5.3.1 (Oct 31, 2021)

  • Added support for Azure SQL Database

New in DB Solo 5.3.0 (Oct 31, 2021)

  • Added support for MySQL 8

New in DB Solo 5.2.5 (Jan 3, 2020)

  • 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

New in DB Solo 5.2.4 (May 7, 2019)

  • 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

New in DB Solo 5.2.3 (Jan 11, 2018)

  • Bug fixes.

New in DB Solo 5.2.2 (Jan 8, 2018)

  • 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

New in DB Solo 5.2.1 (Jan 3, 2017)

  • 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

New in DB Solo 5.2 (Oct 10, 2016)

  • 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

New in DB Solo 5.1 (Oct 11, 2015)

  • Added support for Cassandra
  • Bug fixes

New in DB Solo 5.0.3 (Jun 22, 2015)

  • Added support for SQL Server nokey index columns.

New in DB Solo 5.0.2 (Apr 27, 2015)

  • Bug fixes

New in DB Solo 5.0.1 (Apr 10, 2015)

  • Several Vertica-related bugs were fixed

New in DB Solo 5.0 (Mar 31, 2015)

  • Added support for Java 1.8 on Linux

New in DB Solo 5.0 Beta 4 (Mar 9, 2015)

  • 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.

New in DB Solo 5.0 Beta 3 (Feb 23, 2015)

  • Added support for Mac OS X Yosemite

New in DB Solo 5.0 Beta 2 (Feb 23, 2015)

  • 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

New in DB Solo 5.0 Beta 1 (Dec 8, 2014)

  • 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

New in DB Solo 4.3 (Apr 8, 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 29, 2013)

  • Added support for Vertica

New in DB Solo 4.2.6 (Jul 2, 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 18, 2012)

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

New in DB Solo 4.2.2 (Jun 19, 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 (Nov 30, 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 29, 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 11, 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.1 (Jan 20, 2011)

  • Bug fixes.

New in DB Solo 4.0 (Jan 18, 2011)

  • 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

New in DB Solo 4.0 Beta 1 (Oct 12, 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.7.2 (Mar 17, 2009)

  • Support for PostgreSQL user management was added in this release.

New in DB Solo 3.7 (Feb 10, 2009)

  • Support for custom key bindings
  • Query Editor and Export Tool now support XML and Excel output formats
  • Added support for SQL Server Agent, including configuration for Jobs, Alerts and Operators
  • Query Editor now supports result set comparisons
  • MySQL JDBC driver is now bundled with DB Solo

New in DB Solo 3.5 Beta 1 (Jun 24, 2008)

  • 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
  • Data Import Tool: Import settings can now be saved to a project file
  • Schema Browser: Added support for Oracle table partitions
  • Schema Browser: Added support for Oracle global temporary tables
  • Schema Browser: Added support for Postgres table rules
  • Schema Browser: Data tab can automatically retrieve table/view data when the tab is selected
  • Schema Scripting Tool: Added support for Oracle table partitions
  • Schema Scripting Tool: Added support for Oracle global temporary tables
  • Schema Scripting Tool: Added support for Postgres table rules
  • Query Editor: Result sets can now be exported as SQL INSERT statements
  • Schema Compare Tool: Added support for Oracle table partitions
  • Schema Compare Tool: Added support for Oracle global temporary tables
  • Schema Compare Tool: Added support for Postgres table rules

New in DB Solo 3.0 (Feb 26, 2008)

  • 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
  • Added support for SQL Server 2000 & 2005 user management, including the ability to add/modify/drop database users, database roles and server logins
  • Added support for Sybase ASE user management, including the ability to add/modify/drop database users, database roles and server logins

New in DB Solo 2.2.6 (Oct 1, 2007)

  • Table Data Comparison Tool lets you compare table data between different databases and produce a synchronization script to reconcile the differences.
  • Schema Comparison Tool now supports Sequences and Oracle Packages.
  • J2EE Code Generator. Many-to-many relationships as well as Oracle XMLType are now supported.