Database Comparer VCL V7.0

Can now be used by RAD Studio form designer in 64-bit projects.
April 10, 2018
New Version

Features

  • Embarcadero RAD Studio 10.2, 10.2.2 and 10.2.3 Tokyo support.
  • Minimum IDE versions: Delphi 7.0, C++Builder XE.
  • FireDAC support.
  • Common Table Expressions (CTE) support.
  • Full Firebird 3.0 support.
  • 64-bit platform support.
  • Design-time and runtime packages. The components can be used by RAD Studio form designer in 64-bit projects.
  • New demo projects.
  • FB: Procedure params: NOT NULL support added.
  • The TableDataComparer component for comparing and synchronizing table data.
  • The following SQL servers support are supported: Firebird, Interbase, MSSQL, Oracle, MySQL, Sybase, Postgre SQL.
  • The Database Comparer VCL can be independently compiled with any version of supported database engines.
  • The following database engines are supported: ADO, BDE, DBX, IBX, FIB, IBO, ZEOS, MyDAC, ODAC and IBDAC.
  • The SQLExec component can be used independently from the DBComparer component for executing any SQL scripts.
  • Sybase: Extract and compare PUBLICATIONs.
  • Sybase(ASA): Extract metadata from DB, compare DB-structures, update DB-structure, execute external script.
  • IB/FB: Option "Ignore IBE$... objects" added (ignore objects created by IBExpert).
  • Dependencies of grants with objects.
  • MSSQL2000 keywords. Quoting of identifiers performed only if necessary.
  • Support of CharSet-prefix for strings (e.g.: select _unicode_fss 'ABCD' from rdb$database).
  • Support of Interbase v 4.0 (extract metadata).
  • Domains CHECK altering via ALTER DOMAIN DROP CONSTRAINT / ADD CHECK (IB6.0 and up).
  • TableDataComparer: the "Update Immediately" option.
  • DBStructure: Extract metadata into a script.
  • TableDataComparer: comparing of tables with different structures.

Fixes

  • MSSQL (Transact-SQL) script syntax fixes.
  • TIME datatype with scale: time [ (fractional second scale) ].
  • Derived_table parsing, like this: SELECT * FROM (VALUES (1, 2), (3, 4) ) AS MyTable(a, b).
  • SET-statement, options sequence fix: SET ANSI_PADDING, ANSI_WARNINGS, ANSI_NULLS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER ON.
  • CREATE INDEX with WHERE-clause.
  • FB3: Disabling of the system table updates for Firebird 3.0.
  • FB3: Added support for the Generator increments (START WITH... INCREMENT BY...).
Database Comparer VCL V7.0
Database Comparer VCL

Database Comparer VCL for Delphi, C++Builder

Compare and synchronize SQL database objects and table records.

Get Quote Buy Now

Database Comparer VCL for Delphi, C++Builder is also available in:

Got a Question?

Live Chat with our Clever Components licensing specialists now.