| |
|
Business
/ Databases & Tools
|
|
|
|
|
|
DB Explorer - 3.0.1
|
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.
|
| Software Requirements: |
|
Pentium 266 or better,128 MB RAM
|
| This software is designed to run on the following operating systems: |
|
Windows 95, Windows, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
|
| Keywords: |
|
Database Utility, Compare Database, View Database, Database Difference, Schema, Metadata, Compare Tables, Compare Data, Compare Records, Synchronise Database
|
| Download Links: |
|
|
|
|
|
|
|
| Feedback Summary: |
Show All Feedback (0)
|
|
|
|
 |
|
|
|
| DB Explorer related software |
| Title / Version / Description |
Size |
License |
Price |
| Godsw SQL Compare 2.0 | 6.7 MB | Shareware | $199 |  What is Godsw SQL Compare? Godsw SQL Compare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. Godsw SQL Compare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals and project teams to compare the SQL Server databases on either the same server or different servers. It also provides the functionality for developers to... |
|
| SQLDBCompare V2.4 | 2.6 MB | Shareware | $129 |  What is SQLDBCompare?
SQLDBCompare is the powerful database schema/data comparison and synchronization tool for SQL Server database development projects. SQLDBCompare integrates with SQL Server, providing an effective and effortless database schema comparison for individuals and project teams to compare the SQL Server databases on either the same server or different servers. It also provides the functionality for developers to synchronize the... |
|
| D-Softs DBC 1.22 | 6.1 MB | Shareware | $249 |  DBC ensuring your applications don't fail due to a missing database structure object
DBC (Database Compare) is a fast, comprehensive database structure and data comparison tool.
DBC can compares the schema of two Microsoft SQL Server databases and quickly locates the differences in tables, views, stored procedures or any other object in the database(even included Service Broker) . DBC knows that the dependence relationship is the... |
|
| Free Database Compare 1.0 | 435.0 KB | Freeware | | | The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you have a regularly update database and want to check if the all the changes to the database were committed successfully. After comparing you will be allowed to... |
|
| AdeptSQL Diff 1.95 Build 83 | 3.0 MB | Shareware | $240 |  AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases. The program scans both databases and displays the schema tree view, with all differences color-marked. Navigating through the tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side and produce difference scripts for any choosen part or for the whole schema. The... |
|
|
|
| Other popular software in this category |
| Title / Version / Description |
Size |
License |
Price |
| MSSQL to MySQL Database Converter 2.0.1.5 | 1.3 MB | Shareware | 1980INR |  Database converter is a powerful tool which makes the conversion from MS SQL server to MySQL easy and reliable. You can even convert your large database which contains thousands of records in a matter of a few seconds even if your database merges multiple tables or rows. The database converter software is fully capable to convert entire database or selected table's records easily and efficiently. MSSql to MySql database migrator supports all... |
|
| Free Database Compare 1.0 | 435.0 KB | Freeware | | | The SQL Compare application will allow you to compare the structure of two SQL server databases and display all the differences between them. You can compare databases online or you can take snapshots of the structure of the databases and compare them off-line, which is ideal for when you have a regularly update database and want to check if the all the changes to the database were committed successfully. After comparing you will be allowed to... |
|
| Biometric Employee Time Clock 2.4 | 12.8 MB | Shareware | $99 |  Fingerprint authentication, network support, more detailed reports, QuickBooks® integration, door access control, plus quick and easy setup; make Biometric Employee Time Clock 2.0 the most powerful time and attendance solution to stop time theft.
Biometry is the most accurate way to collect employee time and attendance information. Instead of badges or passwords that can be lost, forgotten or shared, the Biometric Employee Time Clock... |
|
|
|
|
|
|
| |
