The database comparison process has two aspects. DTM Schema Comparer compares the structure (or schemas)
while DTM Data Comparer compares the database content (data rows and values).
To compare schemas, the program enumerates tables, columns, views, stored procedures, indexes, triggers, primary keys and relationships from both databases. In the case of columns with identical names, the tool compares data types, sizes, "null" or "not null" properties, decimal digits, default values, comments and check constraints.
The key product feature is providing visual comparison results. The utility shows two trees with schemas and provides coordinated navigation. If the user selects some object in one of the schemas, the comparison tool selects the object with the same name in the other schema.
Another important part of the process is comparing SQL scripts for complex objects like triggers or stored procedures. The schema comparer offers an effective text comparison tool for this purpose. It shows the two scripts in face-to-face windows with synchronous navigation.