|
|
|
How to compare two databases?
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 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 comparer 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.
|
Download comparison utility
Demo version (?) of Standard or Professional is available free of charge.
About DTM Schema Comparer
- Standard and Professional versions.
- Visual schemas presentation makes comparison process more user friendly.
- The synchronous navigation allows the user to easily compare items in as detailed way as required.
- Project wizard help the user to compare or synchronize schemas by a few clicks.
- Customizable HTML comparison report with thee levels of information detalization.
- Supports ODBC, OCI, OLE DB and IDAPI connections.
See also : schemas synchronization, DTM Data Comparer
|
More screenshots
|
|
|
|
• On-line