Softpedia >Windows >Internet >Servers >Database Utils >DB Solo >  Changelog

DB Solo Changelog

What's new in DB Solo 5.3.5

Sep 24, 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 (Nov 9, 2021)

  • Added support for Azure SQL Database

New in DB Solo 5.3 (Aug 17, 2020)

  • Added support for MySQL 8

New in DB Solo 5.2.5 (Jan 1, 2020)

  • Added a new Data Search Tool
  • DB2 BLOB/CLOB columns are scripted correctly
  • Schema Compare Tool: Trigger enabled/disabled flag can be compared
  • Date Comparison start/end time shown in the HTML report and sync script
  • Date 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 (Nov 8, 2015)

  • Added support for Cassandra
  • Bug fixes

New in DB Solo 5.0.3 (Jun 23, 2015)

  • Added support for SQL Server nokey index columns

New in DB Solo 5.0.2 (Jun 23, 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 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 2 (Mar 9, 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 9, 2014)

  • SQLite-related bug fixes

New in DB Solo 4.2.8 (Jan 14, 2014)

  • Bug fixes

New in DB Solo 4.2.7 (Oct 30, 2013)

  • Added support for Vertica

New in DB Solo 4.2.6 (Jul 1, 2013)

  • Bug fixes

New in DB Solo 4.2.5 (Jun 6, 2013)

  • Added support for SQL Server 2012

New in DB Solo 4.2.4 (Jun 6, 2013)

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

New in DB Solo 4.2.3 (Jun 6, 2013)

  • Added support for MySQL Geometry data types

New in DB Solo 4.2.2 (Jun 6, 2013)

  • 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 (Jun 6, 2013)

  • Bug fixes

New in DB Solo 4.2.0 (Jun 6, 2013)

  • 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 (Jun 6, 2013)

  • 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 (Jun 6, 2013)

  • Bug fixes

New in DB Solo 4.1.0 (Jun 6, 2013)

  • 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 (Jun 6, 2013)

  • Bug fixes

New in DB Solo 4.0.0 (Jun 6, 2013)

  • 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 2.1 (May 24, 2011)

  • Schema Synchronization SQL Script Creation Command-Line Schema Comparison J2EE Code Generator Enhancements

New in DB Solo 2.0.2 (Mar 19, 2007)

  • J2EE Code Generator (POJOs, EJB 3.0 Annotations, JDBC DAO)
  • Explain Plan for DB2
  • Schema Comparison Tool support for PostgreSQL
  • SQL Server 2005 support
  • Sybase 15 support
  • DB2 9.x support