|
|
|
DBDiff is
an ODBC database utility that performs a comparison between two
databases.
Any database that supports ODBC access can be used. The databases DO
NOT have to be of the same type, they don’t even need to be on the
same machine, as long as they are both accessible from the machine
running DBDiff.
DBDiff uses a carefully planned and designed algorithm for
performing the quickest, most accurate comparison between the
databases; this algorithm allows for multiple levels of comparison
to be performed on the databases.
Ver. 5.0 now allows you to compare data by using free form sql
select statements, you can also create database snapshots to perform
off-line comparisons or track historical changes, and many more
new features. |
Table Structure Comparison - This level
will perform a comparison between all tables of the databases. It
will find the tables that are common and perform comparisons between
their respective columns to find and report the differences (i.e.
which columns are common, which are not and what are their
differences). DBDiff can go as deep as the length of a column or can
be set to ignore the length as well as ignore some columns that it
is already known to the user to be different.
Index Comparison - This level will perform a comparison
between all the indexes found on all the tables that are common to
the database. Index Comparison will retrieve all the indexes that
apply to a particular table and compare them with the corresponding
ones on the second database (i.e. DBDiff will report all differences
regarding indexes, their types (unique or not unique) as well as
each of the columns that the index applies to).
Table Data Comparison - This level will perform a comparison
of all tables that are found common (including their columns)
between the databases. It uses a heuristic algorithm to place the
rows that have differences in a manner that “makes sense” for the
user to review. You can set various options to refine the type of
comparison you want to perform. You can tell DBDiff to ignore case
and/or leading or trailing spaces for each row that is compared.
View Structure Comparison - This level will perform a
comparison between all views of the databases. It will find the
views that are common and perform comparisons between their
respective columns to find and report the differences, i.e. which
columns are common, which are not and what are their differences,
DBDiff can go as deep as the length of a column, or can be set to
ignore the length, as well as ignore some columns that it is already
known to the user that they are different.
View Data Comparison - This level will perform a comparison
of the data contained in all views that are found common (including
their columns) between the databases. It uses a heuristic algorithm
to place the rows that have differences in a manner that “makes
sense” for the user to review. You can set various different options
to refine the type of comparison you want to perform; you can tell
DBDiff to ignore case, ignore leading or trailing spaces for each
row that is compared.
Procedure Definition Comparison - This level will perform a
comparison between all procedures of the databases. It will find the
procedures that are common and perform comparisons between their
respective parameters to find and report the differences, i.e. which
parameters are common, which are not and what are their differences,
DBDiff can go as deep as the length of a column, or can be set to
ignore the length, as well as ignore some columns that it is already
known to the user that they are different.
Important: DBDiff does not compare the source code of the
procedures, but only their names and parameters.
In order to make it easy to understand the output of the comparison,
DBDiff creates a report that includes all the differences
(structural, indexes or data) in a user friendly manner. Also
reported is other useful information about the databases and the
comparison.
DBDiff can also generate an Executive Summary with summary
information about a compare. |
|
|
