Softpedia >Windows >Internet >Servers >Database Utils >Database Comparer VCL >  Changelog

Database Comparer VCL Changelog

What's new in Database Comparer VCL 8.1

Jan 21, 2024
  • Implemented Features:
  • RAD Studio 12 Athens support.
  • Minor fixes and improvements.

New in Database Comparer VCL 8.0 (Sep 5, 2023)

  • New Features:
  • RAD Studio 11 Alexandria support was introduced.
  • Connecting databases using Universal Data Access Components (UniDAC) was implemented.
  • The IBObjects connection support was added.
  • A new DB Comparer demo with the UniDAC connection was implemented.
  • The implemented GetDbcBuildNo function returns the current build number.
  • The Grant/Revoke privileges were implemented for IB/FB stored procedures and functions.
  • The "GRANT USAGE ON" statement support for Firebird 3.0 and higher was implemented.
  • The new DBExtract.ExtractObjects property allows defining the DB object types to extract.
  • Subroutines were excluded from comparing Firebird 3.0 and higher databases.
  • A new design-time menu was added to all DBComparer components, including the DBConnection components.
  • Please see the Database Comparer VCL Release History page to get full feature and bug listings.
  • Fixed bugs:
  • The Table Data Comparer didn't syncrhonize data with different key field names in the source and the target tables - fixed.
  • The FireDAC connection component was fixed: added necessary modules to the "uses" section, fixed problems with the "Variable length column [RDB $ FIELD_NAME] overflow".
  • The Database Comparer failed to analyze the Firebird CTE syntax, namely CTEs where the "WITH recursive" statement is used - fixed.
  • The DBComparer failed to parse the "merge into query" and the "extract (week from...)" statements - fixed.
  • The "Column unknown. FNC.RDB$OWNER_NAME" error when extracting Grants in Firebird 2.5 and earlier was fixed.
  • Known problems and restrictions:
  • The cross-server support is not yet implemented when comparing and synchronizing the database structures.
  • The restricted support for some new features in the most recent versions of databases. And now we are working on it.

New in Database Comparer VCL 6.4.908.0 (Dec 28, 2016)

  • Implemented Features:
  • RAD Studio 10.1 Berlin support added;
  • Fixed Bugs:
  • FB: Firebird fixes (generator-fields, etc.);
  • IB: P.RDB$RELATION_NAME field not found in rdb$procedure_parameters (Interbase XE) - fixed;
  • MySQL: MySQL 4.0 "information_schema.routines" doesn't exist - fixed;
  • FB: Access violation when loading the update script to the TIBSQLExec component - fixed.

New in Database Comparer VCL 6.3.0.790 (Dec 28, 2016)

  • Fixed Bugs:
  • FB: Description of procedure params fixes.
  • FB: Type of Domain default value fix.

New in Database Comparer VCL 6.2.0.735 (Dec 28, 2016)

  • Fixed Bugs:
  • FB: Parse Hex-value (0x000...) fix for Int64.

New in Database Comparer VCL 6.2.0.734 (Dec 28, 2016)

  • Fixed Bugs:
  • FB: Extract metadata from DB fix. TYPE OF for procedure params;
  • FB: EXECUTE STATEMENT fix. Optional [DATA SOURCE].

New in Database Comparer VCL 6.2.0.733 (Dec 28, 2016)

  • Implemented Features:
  • RAD Studio XE8 support added;

New in Database Comparer VCL 6.2.0.732 (Apr 2, 2015)

  • Implemented Features:
  • RAD Studio XE6 and XE7 support added;
  • 64bit and Unicode support improved;
  • Fixed Bugs:
  • PostgreSQL: Extract database metadata fixes;
  • PostgreSQL: CREATE FUNCTION, CREATE SEQUENCE fixes;
  • MySQL: Table options, index options fix;
  • IB/FB: Fix trigers parsing;
  • PostgreSQL fixes.

New in Database Comparer VCL 6.1.1.480 (Nov 30, 2013)

  • RAD Studio XE5 support added
  • 64bit support improved
  • Text encoding added: ANSI, Unicode, UTF-8
  • Minor fixes and improvements

New in Database Comparer VCL 6.1.0.479 (Jul 11, 2013)

  • Delphi XE4 and C++Builder XE4 support was added
  • Full Unicode support was implemented
  • 64bit platform is supported
  • Common Table Expressions (CTE) improvements
  • GDS32.DLL is not longer required to connect to FB/IB
  • Minor fixes and improvements

New in Database Comparer VCL 6.0.0.1641 (Mar 18, 2013)

  • Implemented Features:
  • VCL: Delphi XE3 support added;
  • 64bit support;
  • MySQL: PROCEDURE/TRIGGER support added (MySQL v.5.x);
  • Oracle: v.11g suppopt added (11.x).
  • Fixed Bugs:
  • FB: EXECUTE STATEMENT fix;
  • MySQL: PhpMyAdmin script parse fixes;
  • Firebird: "...SIMILAR... ESCAPE..." fix
  • MS SQL: SELECT... FOR-clause fix;
  • MS SQL fixes;
  • TYPE OF COLUMN . declaration fix.

New in Database Comparer VCL 5.0.0.1625 (May 3, 2012)

  • Delphi XE2 and C++Builder XE2 support was added
  • Full Unicode support was implemented
  • 64bit platform is supported
  • Common Table Expressions (CTE) improvements
  • GDS32.DLL is not longer required to connect to FB/IB
  • Minor fixes and improvements

New in Database Comparer VCL 4.0.0.1572 (Oct 6, 2011)

  • RAD Studio XE support;
  • full Unicode support;
  • Oracle: extracting and processing of TYPE's & PACKAGE's added;
  • MySQL: Support for GIS added;
  • IB / FB: Field datatypes conversion improved;
  • TableDataComparer improved.

New in Database Comparer VCL 3.2 build 3.2.47.3 (Mar 2, 2007)

  • Implemented Features:
  • MySQL: "Case sensitive identifiers" option added.
  • Fixed Bugs:
  • dbcTableDataComparer.pas - Delphi5 compilation fix.
  • Fix for packages: ComparerADOD7.dpk, ComparerMyDACD7.dpk, ComparerIBDACD7.dpk, remove using *.dcp libraries.
  • DB2: Parsing fixes: CONNECT, CREATE TABLESPACE, CREATE INDEX, ALTER TABLE...ADD CONSTRAINT.
  • Yaffil: Fix for parse function PAD (...FOR...)