Cross-Database Comparator Pro is the industry standard utility for comparing and synchronizing the contents of two databases.

Cross-Database Comparator Pro widely used for systems when the number of databases must be synchronized periodically or for identifying differences between production and test databases with further their synchronization.

In all scenarios when the data content is a critical value and is spread through different databases you will need a tool for precise comparison and synchronization.

With Cross-Database Comparator Pro 5.0 you will be able to synchronize following database objects:

· Database structure
· Indexes
· Primary keys
· Foreign keys
· Store Procedures
· Table Data

The synchronization can be performed immediately after comparison, using GUI client as well as synchronization SQL script can be generated for further synchronization in off line or remotely mode.

Data synchronization has an additional modes allowing creating different comparison and synchronization strategies including:

· The direction of synchronization;
· The level of synchronization: INSERT, UPDATE and DELETE operations
· Reaction during synchronization session on anticipated DBMS failures.
· Set of table and their synchronization order.
· Time scheduling setting for data synchronization operation.

During synchronization the program automatically defines data types of column participating in synchronization session. This means that the data in column of NUMERIC type can be synchronized to a column of CHAR type.

Using Virtual Tables technology it is possible to cover intelligent synchronization of data. Synchronization repots subsystem creates detailed report about synchronization session in HTML format.

Features of "Cross Database Comparato Pro":

· Compare
Table/view columns properties, primary key properties, index properties, foreign key properties, stored procedure (for different versions of database of same vendor), table/view data, batch comparison.

· Synchronize
Manual synchronization

· Create & Use custom DBBalances internal objects

· Use Batch operations and Scheduling mechanism

· Conversion rules for all data types� pairs across databases of different vendors

· Strategy for comparison, synchronization, migration

· Different types of comparison reports


Limitations:

· 14 day trial
· Nag screen