DB Explorer 3.0.1 Publisher Review:
Compare two database schemas and/or table data rows and report differences. Synchronise the differences for one or other database. Sync Schema generates the SQL DDL statements. Sync Data either transfers the rows or generates SQL DML statements.
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.DB Explorer 3.0.1 details and screenshot
RECOMMENDED TOOLS
Related tags:
» database utility » compare database » view database » database difference » schema » metadata » compare tables » compare data » compare records » synchronise database
Related downloads
Altova MapForce Professional Edition 2009
Altova MapForce Pro is a graphical data mapping tool for XML, DBs, & flat files.
Price: 499$, Rating: 6, Downloads: 1186
Altova MapForce Pro is a graphical data mapping tool for XML, DBs, & flat files.
Price: 499$, Rating: 6, Downloads: 1186
DreamCoder for MySQL Enterprise 4.0
DreamCoder for MySQL is tool for MySQL Database administration and development
Price: 125$, Rating: 10, Downloads: 1185
DreamCoder for MySQL is tool for MySQL Database administration and development
Price: 125$, Rating: 10, Downloads: 1185
Advanced Database Recovery 1.0
Database recovery suite for MS Access MDB databases and DBF databases.
Price: 349.95$, Rating: 10, Downloads: 1184
Database recovery suite for MS Access MDB databases and DBF databases.
Price: 349.95$, Rating: 10, Downloads: 1184
Export Query to Excel for SQL Server 1.02.00
Export Query for Microsoft SQL Server helps to save query results to Excel file
Price: 45$, Rating: 5, Downloads: 1183
Export Query for Microsoft SQL Server helps to save query results to Excel file
Price: 45$, Rating: 5, Downloads: 1183
KeyedAccess for MS Access 3.2
Lock your MS Access app, require users to enter installation-specific UnlockCode
Price: 299.00$, Rating: 10, Downloads: 1181
Lock your MS Access app, require users to enter installation-specific UnlockCode
Price: 299.00$, Rating: 10, Downloads: 1181
EMS DB Extract 2005 for MySQL 2.1
Utility for creating database backups in a form of SQL scripts.
Price: 95.00$, Rating: 9, Downloads: 1179
Utility for creating database backups in a form of SQL scripts.
Price: 95.00$, Rating: 9, Downloads: 1179
MySQL Turbo Manager Free Edition 3.7
MySQL Turbo Manager is tool for MySQL Database administration and development
Price: 0$, Rating: 8, Downloads: 1179
MySQL Turbo Manager is tool for MySQL Database administration and development
Price: 0$, Rating: 8, Downloads: 1179
CDBF for Windows 2.99.02
View, edit and repair the DBF database files, create reports, export data, etc.
Price: 35$, Rating: 7, Downloads: 1178
View, edit and repair the DBF database files, create reports, export data, etc.
Price: 35$, Rating: 7, Downloads: 1178

