DB Explorer 3.0.1

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.

Keywords: database utility, compare database, view database, database difference, schema, metadata, compare tables, compare data, compare records, synchronise database

Click to enlarge

Author:

SLIK Software Ltd     Other programs by SLIK Software Ltd

Downloads:

453

Size:

9205K

Cost:

$260.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Shareware [?]

Operating Systems:

Release Status:

update (2006-10-13)

Recent Changes:

Added columns difference and SQL DDL view

Supported Languages:

English

Additional Requirements:

Pentium 266 or better,128 MB RAM

Database Gate
SQL editor able to connect to every kind of database using ODBC with tools

ApexSQL Diff
Apex SQL Diff is a tool for SQL Server schema comparison and synchronization

AdeptSQL Diff
Database schema difference viewer and synchronization tool for MS SQL Server

eSketch
Analog circuit simulator with rapid schematic capture, many simulation features

DTM Data Modeler
CASE tool for database developers that supports forward and reverse engineering

Exportizer Pro
Database export tool

Exportizer
Free database export tool

Copy Schema for SQL Server
The tool copies database objects definition: tables, views, procedures, keys,etc

DbWeigher
DbWeigher shows differences in the structures of Microsoft Access databases.

Exportizer Pro
Database export tool

Altova MapForce Professional Edition
Altova DatabaseSpy Enterprise Edition
TextPipe Pro
Events Management Software
dbForge Data Compare for MySQL
dbForge Query Builder for MySQL
dbForge Schema Compare for MySQL
RazorSQL
Visual Importer ETL Enterprise 32 Bit
Database Browser Portable

Altova MapForce Enterprise Edition (2129 dl.)
Advanced ETL Processor 32 Bit (1656 dl.)
Database Tour (1653 dl.)
Database Browser Portable (1638 dl.)
Database Tour Pro (1537 dl.)
Altova DatabaseSpy Enterprise Edition (1448 dl.)
Exportizer (1434 dl.)
Visual Importer ETL Standard 32 Bit (1410 dl.)
RazorSQL (1400 dl.)
Altova MapForce Professional Edition (1356 dl.)