DBExplorer Feature List

DBExplorer is a powerful database utility featuring:

Explore database objects
- View/sort data
- SQL Query Wizard
- Built-in HTML report
- Import and Export data to CSV
- Generates SQL "CREATE..." scripts
Compare Database Schemas
- Compare any two databases for structural differences
- Report differences found for:
  - Table and column attributes
  - Indices and primary keys
  - Foreign key constraints
  - Views
  - Stored procedures
- Report any mismatched objects
- Synchronise changes
- Automatically generates the necessary SQL statements to synchronise the changes made in one or other database.
- These can then be applied to the database or saved to a script file for future upgrades.
Compare Database Records
- Compare the data stored in two databases.
  - Exclude specific columns
  - Round up numeric columns when comparing values between different native database providers.
- Report differences found:
  - Identical records
  - Duplicate records
  - Same data, different keys
  - Only in one or other database
- Synchronise changes
  - Copy or update selected rows between databases
  - Includes logic to follow foreign key constraints and transfer any interdependent or related table records.

DBExplorer can compare any OLE-DB accessible databases even if they are on different machines or stored in different vendor databases.

Minimum System Requirements

Microsoft Windows 9x/Me/NT 4/2000/XP
Pentium 200+ Mhz CPU
128 MB RAM
10 MB Free Disk Space
Additional memory and/or large virtual memory settings required to compare large data sets.

DBExplorer

DBExplorer