Cross-Database Comparator Lite 6.0

Cross-Database Comparator Lite 6.0 offers an effective tool which helps you 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 reporters an efng 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.

Major Features:

1. 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 tthe screen or saved in XML/HTML files.
2. Settings:
   • conversion rules for all data types  pairs across databases of different vendors
   • strategy for comparison
   • different types of comparison reports