Cross-Database Comparator Lite 6.0

Cross-Database Comparator Lite is a single integrated working environment to compare database data and structure across any database types. DBBalance’s products take the "pain" out of cross database data and structure comparison shortening and simplifying processes.

Cross-Database Comparator Lite includes comparison reports in XML and HTML formats. These reports can simply be integrated into any reporting or process control system.

DBBalance’s solutions include a wide spectrum of predefined settings and rules (strategy) for comparison. There is no need to configure relations between different data-types and objects between different database types. Simply select the objects you wish to compare and you’re done.

Technical information

There is no need to install and configure a separate set of ODBC drivers. Our products include a set of world leading ODBC drivers.

Using Cross-Database Comparator Lite you can compare any objects between one database type and another.

• Compare:
  • table/view columns properties:
    • column name
    • data type
    • column length
    • column precision
    • column scale
    • column NULL allow
    • column default value
  • primary key properties:
    • primary key name
    • primary key column name
  • index properties:
    • index name
    • column name
    • index owner
    • unique
    • sort type
  • foreign key properties:
    • foreign key name
    • primary table name
    • primary column name
    • foreign table name
    • foreign column name
    • update rule
    • delete rule
  • stored procedure (for different versions of database of same vendor):
    • stored procedure name
    • stored procedure body
  • table/view data:
    • all or selected table/view data
  Comparison results can be reported to the screen or saved in XML/HTML files.
• Settings:
  • conversion rules for all data types’ pairs across databases of different vendors
  • strategy for comparison
  • different types of comparison reports