About Database Comparer VCL & Tools Bundle

Compare and synchronize SQL database objects and table records.

Database Comparer VCL helps to compare, synchronize and update database structure. You can compare one database with another or a database with a SQL/DDL script. You can view all differences between databases and execute automatically generated scripts to eliminate all or selected differences. The library includes more than 25 components for database development. Database Comparer Tools helps you compare one database with another or databases, with SQL/DDL scripts or even two SQL/DDL scripts. Database Comparer Tools includes an intelligent and robust synchronization algorithm.

Database Comparer VCL Features

  • Compare two databases, a database and a SQL/DDL script or two SQL/DDL scripts.
  • Synchronize data between two database tables.
  • Extract database structure.
  • Compare specific database objects or entire databases.
  • Full source code for all components.
  • 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 you can compare SQL Server, Oracle, MSSQL, MySQL, InterBase (FireBird, Yaffil), Sybase and Postgre SQL databases. Most popular database libraries such as ADO, BDE, InterBase Express, FIBPlus, IBObjects and ZeosLib supported directly. MyDAC, ODAC and AnyDAC are also supported.

Component List

  • DB Comparer - Compares two databases (Master and Target) and generates the update script.
  • Table Data Comparer - Synchronizes table records between two different databases.
  • DB Connection - Provides connection to both Master and Target databases.
  • DB Structure - Represents the database structure: tables, triggers, stored procs and other database objects.
  • DB Extractor - Extracts the database objects and saves it in to the DatabaseStructure component.
  • Script Extractor - Parses the SQL/DDL script, extracts all database objects and saves it in to the DatabaseStructure component.
  • SQL Executor - Executes an SQL script and updates the database structure.

Database Comparer Tools Features

  • Compare database with database, database with SQL/DDL script and SQL/DDL script with SQL/DDL script.
  • Compare and synchronize data between two database tables.
  • Optionally select which objects (domains, tables, procedures, triggers etc.) should be compared.
  • Batch mode for most operations.
  • Browse Master and Target structure trees and visually display the differences between them.
  • Final update SQL script can be edited or broken onto separate steps using built-in SQL editor with highlight feature. You can manually change steps order or optionally disable selected steps.
  • Build-in additional functionality such as: drop constraints, backup/restore, database validation and many other useful features.