| |
|
|
| 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. |
| Other software from this author: | - ODBC View 3.1.0 — ODBCView is a free SQL query tool to view and export data from any OBDC database. Data is displayed on a read-only grid and can be exported to a CSV or HTML report. Note, any valid SQL statements can be executed including SQL UPDATE and DELETE stmts.
| | Show all software from this author |
Description:
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 CatalogBrowse 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 SchemaCompare 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. | System Requirements:
Pentium 266 or better,128 MB RAM | Change Info:
Added columns difference and SQL DDL view | | DB Explorer 3.0.0 Download from sliksoftware.com |
| Similar software: | - DatabaseBridge 1.006 — DatabaseBridge is a powerful cross-DBMS data migration, data comparison and distributed query tool that also performs validation of flat data and is a multi-DBMS browser. A cross-DBMS data transfer of a million records can be completed in minutes
- Universal Table Browser 2.0 — Universal Table Browser is a Query Tool giving you access to any database using ODBC. A graphical user interface means that you can simply point and click your way to complex SQL statements or use the SQL editor to write your own query.
- ConversionTool 4.2.2 — Tool reengineers BTrieve databases and converts comprehensively Access databases into SQL Server preserving all table structure details, and supports the conversion of the views and procedures. Moreover, the tool supports solution of problems.
| | Find all software similar on DB Explorer 3.0.0 |
|
