Database Comparer ActiveX for ASP, VBScript, JavaScript（英語版）

データベースの構造の比較、同期、更新

Clever Components 社の製品
2010 年より日本国内にてComponentSourceで販売中。

価格:¥ 17,820 (税込)〜 バージョン: 3.2 更新日: May 20, 2019

Database Comparer ActiveX for ASP, VBScript, JavaScript（英語版） のスクリーンショット

Database Comparer ActiveX for ASP, VBScript, JavaScript について

データベースの構造の比較、同期、更新

Database Comparer ActiveX for ASP, VBScript, JavaScript helps you compare one database with another or a database with a DDL/SQL script or even two DDL/SQL scripts. It takes a Target database or Target SQL/DDL script and compares it to a Master database or Master SQL/DDL script. It locates all structure differences and prepares a SQL script which can be applied to the Target to make its structure equal to the Master. It extracts all objects, descriptions and links from both Master and Target and then compares actual objects.

Supported Databases

  • InterBase SQL server and it's clones
  • FireBird
  • SQL Anywhere
  • MySQL

Features

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