Database Comparer.

This tool is designed to help you compare two database structures and create the "script of difference". You can compare two databases, database and SQL script file or two script files. Actually it compares two script files and automatically extracts metadata for selected databases.

The first so called "source" database is the database with outdated structure. The second "target" database is the database with the morden structure and our "source" database must have the same structure as a "target". So the "script of difference" is a script which can update source database structure to the target database structure.

You can change the following comparing options:

  1. Normal/Paranoia - in a "paranoia" mode IBAdmin changes the creation order of the database objects and makes additional analyses. This mode should be used when you have a databases with a very complexobject dependencies so your "script of difference" cannot be executed successfully.
  2. Normalized - when checked (default) IBAdmin does not care about extra spaces, carrage returns and other control symbols in your Stored Procedure or Trigger text.
  3. Objects to compare - you can select the object types that will be compares. For example, you may want to compare only table changes.