|
|
DBExplorer
-
Version
2.0.0
DBExplorer is a powerful database utility that allows
you to compare any two databases and report the
structural and/or data differences between them. It
then enables you to synchronize the differences.
DBExplorer supports any OLE DB or ODBC compliant
database which includes all the mainstream databases
including MS SQL Server, Oracle, DB2, Access etc.
Database Catalog
Browse a databases schema and/or data. Provides a
built in reporting tool and an export to file feature
so you can document the database schema and records.
An SQL query wizard allows you to select particular
columns and filter specific records. It can also
generate SQL DDL scripts to reproduce or record the
database structure.
Compare Schema
Compare the structure or metadata between two versions
of a database. The objects compared include tables,
columns, views, procedures, indexes and foreign and
primary keys constraints. Once the comparison is
complete DBExplorer presents a detailed on-screen
summary. From here DBExplorer can automatically
generate the appropriate SQL statements (ie, SQL DDL -
Data Definition Language) to bring the database up to
date. Depending on the differences detected this may
be a "CREATE TABLE/VIEW/PROCEDURE" or a "ALTER TABLE
ADD COLUMN…" type statement. These generated SQL
statement can be saved to a separate SQL script file
for later execution or applied directly.
The entire comparison results can also be saved to a
document file or printed out as a HTML report.
Compare Data
DBExplorer uses a sophisticated internal hashing
algorithm to report the differences between the data
stored in two databases. The databases to compare do
not have to reside on the same machine or even in the
same RDBM system. Comparison includes records that are
identical, duplicated or having the same data but
different keys as well as being present in only one of
the databases. Once the comparison is complete you can
choose to synchronise selected records to one or other
database.
|