Data Validator v7

The Data Validator is a utility that compares the rows of one or more tables in a schema of a database against the rows of the tables with the same names in a schema of another database. The Data Validator generates a summary of the comparison, noting the number of rows whose column values differ. A file containing detailed information regarding any differences is also generated.

The two databases being compared are referred to as the source database and the target database. The source database can be of type Oracle, EnterpriseDB, SQL Server, Sybase, or MySQL. The target database must be either Oracle or EnterpriseDB.

An EnterpriseDB database type means either an EDB Postgres Advanced Server database or a PostgreSQL database.

The tables available for comparison are those found in the schema of the source database. Tables in the target database that don't exist in the source database schema are ignored.


The Data Validator doesn't validate columns having the following data types. Tables containing one or more columns of these types are only partially validated.

  • REF
  • BLOB
  • CLOB
  • RAW

Regarding the use of the Data Validator with tables in an Replication Server single-master or multi-master replication system, be sure all synchronization replication between the source and target Replication Server tables is complete before using the Data Validator. If synchronization replication is still in progress, the Data Validator will likely report differences in table content.

installation_and_configuratiin_datavalidator perform_datavalidation