About Database Comparer VCL for Delphi, C++Builder

Compare and synchronize SQL database objects and table records.

Database Comparer VCL compares and synchronizes database structure (metadata) and table data for many popular databases. The list of supported databases is constantly updated and includes InterBase, FireBird, MySQL, MSSQL, Oracle, Sybase, PostgreSQL, DB2, PervasiveSQL, MSAccess, Paradox, DBASE, and other databases that can be accessed via the OLEDB provider. Most popular connection libraries, such as FireDAC, ADO, and IBX are also supported, along with several third-party libraries, such as UniDAC, IBDDAC, IBObjects, ZEOS and AnyDAC. You can even use outdated connection methods, such as BDE or FIB to connect to your databases. The Database Comparer VCL product includes more than 40 components for database-related development. All the components are constantly refined and improved.

Database Comparer VCL Features

  • Connect to a database and extract database structure.
  • Compare two database structures and produce an update SQL script.
  • Update the target database structure using the update SQL script and synchronize the two databases structures.
  • Compare two SQL DDL scripts, a database and an SQL script, and synchronize a database with an SQL script.
  • Compare and synchronize data in two tables of the same database, two databases, or even two databases of different type.
  • Synchronize Firebird, Interbase, MS SQL, Oracle, MySQL, Sybase, Postgre SQL, and may other popular databases.
  • Compare and synchronize stored procedure, trigger, and function scripts.
  • Compare tables, constraints, indices, triggers, generators, stored procedures, UDFs, grants, roles, and many other database objects, depending on the database type.
  • Extract database structure (metadata) to a file.

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.