DB Explorer Icon

DB Explorer

Compare two database schemas and/or table data, report differences and sync.

DB ExplorerOverview

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.

NEW

Added columns difference and SQL DDL view

DB ExplorerInformation

Version
3.0.1
Date
10.13.06
License
Trial
Language
English
File Size
8.99 MB
Category
Operating Systems
Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP
System Requirements
Pentium 266 or better,128 MB RAM

DB ExplorerPrevious Versions

ODBC View Icon
ODBCView is a free SQL query tool to view and export data from any OBDC database
Free
More
DB2 Express-C Icon
IBM DB2 Express-C is a free, unlimited-use database for relational and XML data.
Free
School Management System Icon
SMS - School Management System is a large database system.
Free
MaxDEA Icon
MaxDEA is an easy-to-use but most powerful Data Envelopment Analysis software.
Trial
ADVANCED HOSPITAL MANAGEMENT SYSTEM Icon
complete package one needs for a hospital to deal with all the day to day
Free
SPSS Icon
IBM SPSS puts the power of advanced statistical analysis in your hands.
Trial
DBISAM viewer Icon
DBISAM Viewer: direct and fast read any DBISAM table
Trial
College Management System Icon
It is an automated system for managing the data of College or School.
Free
Microsoft Office Access 2010 Runtime Icon
It enables you to distribute Access 2010 applications.
Free
More