VCL Clever Database Comparer VCL

FireWind

Свой
Регистрация
2 Дек 2005
Сообщения
1,957
Реакции
1,199
Credits
4,009
Clever Database Comparer VCL

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.

Compare databases using direct connection to the databases

This method can be used when both Master and Target databases are online.
Please see the diagram and the detailed comments below. This diagram shows how to compare and update two Interbase databases. You can connect to any other supported database (MS SQL, Oracle, MySQL, Sybase, PostgreSQL, dBASE or Paradox) using the corresponding TDBCConnectionXXX component.

1612556471028.png
TIBDatabase component from IBExpress library provides connection to the Master and Target databases respectively.
TDBCConnectionIBX component connects to the Interbase database using the IBExpress database engine.
TIBDBExtract component connects to the database via TDBCConnectionIBX, extracts all metadata from it and then feels given TDBStructure component with the database structure descriptions.
TDBStructure component stores the database structure.
TDBComparer component analyzes structures of both Master and Target databases stored within the TDBStructure components and generates the resulting update script. The update script is just a regular DDL/SQL script which after being applied to the Target database makes its structure identical to the Master database.
TIBSQLExec component can take the update script generated by the TDBComparer component and run it against the Target database. Given script will be executed by TIBSQLExec component on "statement by statement" basis and thus all errors which may occur during the Target database structure conversion will be detected and properly resolved.

Compare database DDL scripts

This method can be used when only DDL/SQL scripts of Master and Target databases are available.
Please see the diagram and the detailed comments below.
1612556522066.png
TIBScriptExtract component reads and parses the DDL/SQL script, extracts all metadata and then feels given TDBStructure component with the database structure descriptions.

TDBStructure component stores the database structure.
TDBComparer component analyzes structures of both Master and Target databases stored within both TDBStructure components and generates the resulting update script. The update script is just a regular DDL/SQL script which after being applied to the Target database makes its structure identical to the Master database.

Compare databases using direct connection and DDL script

This method is basically the combination of the Для просмотра ссылки Войди или Зарегистрируйся and Для просмотра ссылки Войди или Зарегистрируйся methods.
The diagram below shows how you can update the Target database structure using the Master DDL/SQL script loaded from a file.
1612556559079.png

Compare Table data

Please use the TTableDataComparer component if you want to synchronize data in database tables. The following diagram shows how to set-up this component for synchronizing two database tables.
1612556584893.png
TIBDatabase component from IBExpress library provides connection to the Master and Target databases respectively.
TDBCConnectionIBX component connects to the Interbase database using the IBExpress database engine.
TTableDataComparer component compares and synchronizes table records between two Interbase databases. Please use a set of TDBCConnectionXXX components for connecting to any other supported database (MSSQ, Oracle, MySQL, Sybase...).

Synchronize multiple databases

Let's say you have number of Target databases all with different structures and these databases needs to be synchronized with the Master database.
In this case you need to extract the Master database metadata into a DDL/SQL script file and then compare all Target databases against this Master script.
This is the most suitable for version control applications and for updating client (Target) databases using only Master DDL/SQL script, without bringing whole Master database.

Home: Для просмотра ссылки Войди или Зарегистрируйся
Copyright © Для просмотра ссылки Войди или Зарегистрируйся
 

FireWind

Свой
Регистрация
2 Дек 2005
Сообщения
1,957
Реакции
1,199
Credits
4,009
Clever Database Comparer VCL v7.1.916 for Delphi 7-10.3 & C++Builder XE-10.3 [full source]
Скрытое содержимое могут видеть только пользователи групп(ы): Premium

password: dumpz.ws
 
Последнее редактирование:

FireWind

Свой
Регистрация
2 Дек 2005
Сообщения
1,957
Реакции
1,199
Credits
4,009
Clever Database Comparer VCL v8.0.924.0 for Delphi 7-11 & C++Builder XE-11 [full source]
Скрытое содержимое могут видеть только пользователи групп(ы): Premium

password: dumpz.ws
 
Регистрация
4 Окт 2008
Сообщения
25
Реакции
14
Credits
459
К сожалению, в последнем архиве файлы имеют нулевой размер:
dbcASEScriptExtract.pas
dbcComp_Exc.pas
dbcComparerReg_FIB.pas
dbcComparerReg_UniDAC.pas
dbcConnection_DBXDB.pas
dbcConnection_FIBDB.pas
dbcDB_PGDAC.pas
dbcTypes.pas
 

FireWind

Свой
Регистрация
2 Дек 2005
Сообщения
1,957
Реакции
1,199
Credits
4,009