Database Comparer VCL & Tools Bundle について

SQLデータベースのオブジェクトとテーブルのレコードを比較、同期

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 Tools includes an intelligent and robust synchronization algorithm.

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.

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.