Geodatabase comparison

When you are evaluating the changes that have been made to a data model, you may want to compare it with the existing version to see the differences. For example, you may want to see how many fields have been added to the new schema to determine whether or not an update is necessary.

The Data Comparison tool allows you to compare an existing database to an updated version of the data model. Using this tool, you can track the differences between various aspects of the database including the schema, geometry, attributes, and spatial reference. You can also choose to compare the databases based on all these aspects or a specific one. The particular items that are compared for each comparison type are displayed in the table below.

Comparison type

What is compared

ALL

  • Extension class IDs
  • Feature class extents
  • Feature class feature types
  • Feature class shape types
  • Field existence
  • Field length
  • Field type
  • Field var type
  • Subtype default value
  • Table or feature class existence
  • Table row counts
  • XY precision

ATTRIBUTES_ONLY

  • Feature class field values
  • Number of table fields
  • Number of table rows
  • Subtype default values
  • Subtype names

GEOMETRY_ONLY

  • M tolerance
  • Table or feature class existence
  • Z precision
  • Z tolerance

SCHEMA_ONLY

  • Field types
  • Field lengths
  • Field var types
  • Geometry definition
  • M-values
  • Number of table fields
  • Table or feature class existence
  • Table fields
  • Z-values

SPATIAL_REFERENCE_ONLY

  • M tolerance
  • XY precision
  • Z precision
  • Z tolerance

Database items compared

When you are comparing databases, you also have the ability to ignore certain aspects of it, such as m and z. The Data Comparison tool provides the following options:

Additionally, you can also choose to stop the comparison process at the first instance of a difference between the two databases and choose to only record errors in the data comparison report.

The data comparison report

The results of the database comparison are output to a text file that contains the following fields for each feature class or table:

Example of a Data Comparison Report
Example of a Data Comparison Report

4/17/2012