Site Map Contact Us Home
E-mail Newsletter
Subscribe to get informed about
Clever Components news.

Your Name:
Your Email:
 
SUBSCRIBE
 
Previous Newsletters
 




Products Articles Downloads Order Support
Customer Portal      

Database Comparer ActiveX for ASP, VBScript, Javascript

Database Comparer ActiveX for ASP, VBScript, Javascript

Database Comparer ActiveX v 3.2 (May 20, 2019)

The Database Comparer ActiveX represents the com-based superstructure on the Database Comparer VCL edition. The main purpose of the Database Comparer library is to provide to the end-users the higher-level interface available in any languages with com-support routines, such as Visual Basic, Visual C++, VBScript, JavaScript and many others.

Database Comparer helps you to compare, synchronize and update databases structure. You can compare one database with another database or database with DDL/SQL script or even two DDL/SQL scripts!

Database Comparer implements highly intelligent and robust synchronization algorithm. During first comparison step it takes Target database or Target SQL/DDL script and compare it to the Master database or Master SQL/DDL script trying to locate all structure differences and prepare final SQL script which will be applied to the Target and make its structure equal to Master structure.

At this stage Database Comparer extracts all objects, descriptions and links from both Master and Target structures and then compares actual objects from Master with objects from Target building final update SQL script. After final update SQL script is ready you can apply it to the Target database if it is available or just save it to the file and run it later.

End-User License Agreement

Supported Databases

  • InterBase SQL server and it's clones - FireBird and Yaffil (Yaffil team recently announced merge with FireBird)
  • SQL Anywhere>
  • MySQL

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

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

Both SQL Anywhere and MySQL are supported with restrictions. Database Comparer can only work with SQL Anywhere scripts and can not connect directly to SQL Anywhere. You will have to provide Database Comparer with both master and target database scripts which will be parsed and compared. Result will be the DDL/SQL script which needs to be applied to the target database in order make target database structure fully identical to the master database structure.

The most unique features of the Database Comparer ActiveX are ability to perform full analysis of all types of the database objects and it's properties and generate the DDL/SQL script which will transform structure of the target database and makes it totally 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 errors which may occur during target database structure conversion process will be detected and properly resolved.

Component List

  Component   Description
 DBComparer Compares two databases and generates result script to the updated Target database
 DBStructure The database structure component. Containts all database objects
 IBDBExtract Extracts the InterBase database to the DBStructure
 IBScriptExtract Extracts the InterBase database metadata from a script (*.DDL, *.SQL) to the DBStructure
 IBSQLExec Stores the updated SQL script to file and modifies the target InterBase database after comparing
 SAWScriptExtract Extracts the SQL Anywhere database metadata from a script to the DBStructure
 MySQLScriptExtract Extracts the MySQL database metadata from a script to the DBStructure

Distribution Packages

  Package   Demo   Order
 Database Comparer ActiveX Free Trial Buy Now

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

The installation includes ocx with ActiveX components, Overview and EULA files. The Demo-program is also installed.

Demo version information

Free demo version of Database Comparer ActiveX is available for evaluation purposes only. Demo version raises warning message with evaluation information on any actions with database structure, all other features are completely available.

For more details please contact us at Customer Portal.

    Copyright © 2000-2024