Free Software Downloads::Business::Databases & Tools::DB Explorer

DB Explorer 3.0.1

DB Explorer screenshot

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

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.


[Download] (9205 K)

Program Details


Released: 2006-10-13
More:All programs by this author
Downloads: 223
License Type: Shareware
Platform: Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP
Homepage: http://www.sliksoftware.co.nz/products/dbexplorer/
Price: $260.00 US

Related Listings

   SQL Examiner 2010 R2
SQL compare and synchronization with SQL Server, Oracle or MySQL.
   SQL7Print
Document schema of your Microsoft SQL Server 7 database
   Database Gate
SQL editor able to connect to every kind of database using ODBC with tools
   InsideCAT Lite Edition
Automatic disk indexer for all your PC disks collection (never lose a file)
   EXIFViewer
EXIF Viewer is the most efficient tool for dealing with extended info in photos
   DB Explorer
Compare two database schemas and/or table data, report differences and sync.
   DbDefence
Encrypts SQL Server 2012,2008 R2, 2005 databases transparently including log and
   CrossIPTC
Convert IPTC text accent characters in images Mac to PC, synchronise XMP to IPTC
   EMS DB Extract for PostgreSQL
Utility for creating PostgreSQL database backups in a form of SQL scripts.
   SQL Server Comparison Expert
Compare and Synchronize mssql Database with SQL Server Comparison Expert.
   Kalimages
Image indexation database, edit and search IPTC headers from photo digital files
   csImageFile
ASP image resize component. Edit jpg, gif, tiff and others. Metadata support.
   MetaViewer
Metaviewer extracts file system and OLE metadata contained in MS Office files
   Image Constructor
Creates pictures with texts and small images over background.
   DTM Data Comparer
DTM Data Comparer is a visual tool for data comparison and synchronization