Database Comparer assists you to analyse, synchronize and update databases structure. You may examine one database with another database or database with SQL/DDL script or even two SQL/DDL scripts.

Database Comparer uses highly, extremely and strong synchronization algorithm. During first comparison path it takes Target database or even Target SQL/DDL script and compare it to the Master database or Master SQL/DDL script attempting to measure all structure differences and develop final SQL script which will be distributed to the Target and make its structure match the Master structure.

As this step was taken, Database Comparer removes all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from Target creating final update SQL script. After final update SQL script is ready you can put it to the Target database if it is available or just save it to the file and take care of it later.

Database Comparer is designed to support these king of servers:

InterBase SQL server and it's copy's - FireBird and Yaffil (Yaffil team recently announced team-up with FireBird)
SQL \Anywere

Borland InterBase Express components library (IBX) is used by default to apply with InterBase / FireBird. Alternatively Database Comparer can support Fast InterBase Plus components by Devrace (FIBPlus) and Interbase Objects (IBO) library.

Database Comparer can relate directly to the InterBase/FireBird databases via IBX or FIBPlus thus directly executes all operations such as database metadata extraction, SQL statements and scripts execution etc.

SQL Anywhere support is restricted. Database Comparer can only work with SQL Anywhere scripts and can not connect directly to SQL Anywhere. You will have to supply Database Comparer with both master and target database scripts which will be analised and compared. Result will be the DDL/SQL script which needs to be practiced to the target database in order to make target database structure totally identical to the master database structure.

The most incomparable features of the Database Comparer VCL are capability to perform full analysis of all types of the database objects and it's properties and produce the DDL/SQL script which will transform structure of the target database and makes it fully identical to the structure of the source database.

Generated DDL/SQL script can be executed by TIBSQLExec component on "statement by statement" basis and thus all problems which may occur during target database structure conversion process will be observed and properly resolved.

Limitations:

· Database Comparer library comes with total sources (demo versions does not have sources), detailed help and demo projects.

What News Does These Release Offers:

· Delphi 2005 support.
· Comparing of the MySql scripts was implemented.
· Some Implemented Features:
· MySQL: "Case sensitive identifiers" option was added.
· Fixed Bugs:
· dbcTableDataComparer.pas - Delphi5 compilation fix.
· Fix for packages: ComparerADOD7.dpk, ComparerMyDACD7.dpk, ComparerIBDACD7.dpk, remove using *.dcp libraries.
· DB2: Parsing fixes: CONNECT, CREATE TABLESPACE, CREATE INDEX, ALTER TABLE...ADD CONSTRAINT.