The Database Comparer VCL represents 100% Delphi VCL components for Borland Delphi / C++Builder. These components allow you to compare and synchronize SQL database objects and table records for many popular databases. You can view all the differences between databases and execute an automatically generated script to eliminate all or selected only differences. The library includes more than 25 components for Database development and its code is constantly being refined and improved.

Features at a glance:

Compare two databases, database and SQL/DDL script, two SQL/DDL scripts
Synchronize data between two database tables
Extract database structure
Compare specific database objects or entire databases
Royalty free licensing. Free Unlimited Email support
Fully-indexed help documentation. Delphi and C++Builder demos code

Connect to most popular databases

With Database Comparer VCL components you can compare Oracle, MSSQL, MySQL, InterBase (FireBird, Yaffil), Sybase and Postgre SQL databases. SQL Server 2005 is also supported.

Most popular database libraries such as ADO, BDE, InterBase Express, FIBPlus, IBObjects and ZeosLib supported directly. MyDAC, ODAC and AnyDAC are also supported.

These lists are constantly updated and support for new databases will be added soon.

What's new

RAD Studio 10 Seattle support - Delphi 10, C++Builder 10;
Win64 (x64) binaries were added to the installation;
Run-time packages for Delphi XE2...XE8, 10 Seattle.
MySQL: PROCEDURE/TRIGGER support added (MySQL v.5.x);
Oracle: v.11g suppopt added (11.x).

Implemented features

    A new component for comparing and synchronizing table data was added.
    The following SQL servers support was added: MSSQL, Oracle, MySQL, Sybase, Postgre SQL.
    Now 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.
    Now the SQLExec component can be used independently from DBComparer component for executing any SQL scripts.
    TableDataComparer: Sybase support was added.
    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 the objects are added.
    MSSQL2000 keywords are added. Quoting of identifiers performed only if necessary.
    MSSQL: Remove dependencies for field before ALTER COLUMN.
    Support of CharSet-prefix for strings was added (e.g.: select _unicode_fss 'ABCD' from rdb$database).
    Support of Interbase v 4.0 restored (extract metadata).
    Domains CHECK altering via ALTER DOMAIN DROP CONSTRAINT / ADD CHECK (IB6.0 and up).
    TTableDataComparer.UpdateImmediately added.
    TDBStructure: Extract metadata into script.
    TTableDataComparer: comparison of tables with different structure.

Fixed Bugs

    FB: Description of procedure params fixes;
    FB: Type of Domain default value fix;
    FB: Parse Hex-value (0x000...) fix for Int64;
    FB: Extract metadata from DB fix. TYPE OF for procedure params;
    FB: EXECUTE STATEMENT fix;
    MySQL: PhpMyAdmin script parse fixes;
    Firebird: "...SIMILAR... ESCAPE..." fix;
    Issue: 0000423 (by jamaakubaff). [url=http://barry.exp-host.ru/tracker/view.php?id=423;]http://barry.exp-host.ru/tracker/view.php?id=423;[/url]
    MS SQL: SELECT... FOR-clause fix;
    FB 2.5: TYPE OF COLUMN <table />.<column /> declaration fix.

[/b]

[b] Only for V.I.P

Warning! You are not allowed to view this text.