Database Comparer VCL for Delphi, C++Builder

SQL 데이터베이스 개체 및 테이블 레코드를 비교하고 동기화합니다.

Clever Components사에서 공개
2010년 부터 ComponentSource에서 판매중

가격: ￦ 510,100 버젼: 8.1.x 업데이스 날짜: Jan 22, 2024

Database Comparer VCL for Delphi, C++Builder 스크린샷

Database Comparer VCL for Delphi, C++Builder 관련 정보

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 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.