Cross-Database Comparator Pro 6.0

Cross-Database Comparator Pro 6.0 is a single comprehensive and integrated enterprise 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 Pro 6.0 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 and replication. 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. You can always control the settings and define your own rules, if your process requires any special definitions.

Using Cross-Database Comparator Pro 6.0 you can use mass compare in "Batch" mode – just select all the objects you wish to compare to create a comparison strategy and execute it immediately or in scheduling mode.

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 Pro 6.0 you can compare any set of objects between one database type and another.

• Compare, Synchronize:
  • 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
    • batch comparison:
      • including comparison of the table structures, primary keys, indexes, foreign keys, data
      • scheduling is available
    Comparison results can be reported to the screen or saved in XML/HTML files.
  • Synchronize:
    • Manual synchronization
      • columns properties
      • primary key properties
      • index properties
      • foreign key properties
      • table/view data
  • Create the strategy for full table or partial list of objects
• Create & Use custom DBBalance’s internal objects:
  • virtual tables
  • stored queries
  • table/view filters
• Use Batch operations and Scheduling mechanism:
  • for comparison (including comparison of structures, primary keys, indexes, foreign keys, table/view data)
• Settings:
  • conversion rules for all data types’ pairs across databases of different vendors
  • strategy for comparison, synchronization, migration
  • different types of comparison reports