Database Comparer Tools Releases

Clever ComponentsDatabase Comparison Tools
Version 8.0 (Dec 20, 2021)

Learn what's new across releases, with details of features, enhancements, and resolved issues.

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Database Comparer Tools V7.1.0.1688Aug 2, 2019
Fixes
  • FB3: Procedure dependencies.
  • Extract function arguments.
  • FB3: CONTAINING.
  • FB3: OVER-clause with ROW_NUMBER(), RANK(), DENSE_RANK().
  • FB3: UDF fixes. CSTRING datatype, MODULE_NAME, ENTRY_POINT keywords.
  • FB 2.1+: CREATE COLLATION.
  • FB3: FUNCTION (...) RETURNS param DETERMIMISTIC.
  • FB: Computed field with datatype (erroneous script).
  • FB3: Local declaration procedure/function into proc/func body.
  • FB3: Default values for proc-params fix (exptact from DB).
Database Comparer Tools V7.1.0.1681May 20, 2019
Features
  • Added CROSS APPLY statement for SELECT command.
  • Package support added to Firebird 3.0 engine.
  • Implemented parsing/building of CREATE FUNCTION statements.
  • Introduced DATEADD, DATEDIFF, and OVERLAY functions parsing for Firebird 3.0.
  • Added MS SQL Server CTE support.
  • Implemented default values for stored procedure parameters.
  • Added BDE connector to DBC Datapump utility.
Fixes
  • The database comparer cannot parse the "rows 1" statement in triggers - fixed.
  • Crash comparing two oracle 11g2 databases - fixed.
  • The Invalid typecast error occurs when extracting the Firebird 3.0 internal functions - fixed.
  • The SQL LIST ALL and DISTINCT statements cause the parsing error in Firebird 2.6 - fixed.
  • The valid Firebird 2.5 trigger with the script containing the CTE syntax is marked as invalid - fixed.
  • The extractor cuts the final ")" from the stored procedure code - fixed.
  • The updating of the Database Default Charset failed - fixed.
  • The problems with parsing of computed fields of NUMERIC (nn, xx) type were fixed.
  • The NOT NULL table columns are not changed to NULL for Firebird 3.0 - fixed.
  • The problems with parsing of stored procedure scripts containing the PERCENT and OPTION statements were fixed.
  • The comparer doesn't create the global temporary table, but it creates all the indices, primary keys, and foreign keys that belong to GTT - fixed.
  • The Connection String alias parameter is not saved - fixed.
  • The Access Violation error occurs when parsing MS SQL scripts - fixed.