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.
VERSION HISTORY
- Version 3.0.1 posted on 2006-10-13
Added columns difference and SQL DDL view
Program Details
- Category: Business > Databases & Tools
- Publisher: SLIK Software Ltd
- License: Free Trial
- Price: $290.00
- Version: 3.0.0
- Platform: windows
EULA
LICENSE AGREEMENT You should carefully read the following terms and conditions before using this software. Unless you have a different license agreement signed by SLIK Software Ltd the use or installation of this software indicates your acceptance of this license agreement and warranty. 1. REGISTERED VERSION A single registered copy of DB Explorer may either be used by a single person who uses the software himself on one or more computers, or installed on a single computer and used by multiple people, but not both. You may access the registered version of DB Explorer through a network, provided that you have obtained individual licenses for the software covering all computers that will run the software from the network. For instance, if seven different workstations will access DB Explorer on the network, you will need a seven-user DB Explorer license, whether they use DB Explorer at different times or concurrently. 2. SHAREWARE VERSION / EVALUATON AND REGISTRATION This is not free software. Subject to the terms below, you are hereby licensed to use this software for evaluation purposes without charge for a period of 30 days. If you use this software after the 30 day evaluation period a registration fee of NZ$ 399 is required. Credit card ordering and quantity discounts are available, as described in the section "Secure On-Line Order". Unregistered use of DB Explorer after the 30-day evaluation period is in violation of New Zealand and international copyright laws. 3. COPYRIGHT The Software is confidential copyrighted information of SLIK Software Ltd. You shall not modify, decompile, disassemble, decrypt, extract, or otherwise reverse engineer the Software. The Software may not be leased, assigned, or sublicensed, in whole or in part. The commercial version of DB Explorer may either be used by a single person who uses the Software personally on one or more computers, or installed on a single workstation used non-simultaneously by multiple people, but not both. You may access a version of DB Explorer through a network, provided that you have obtained individual commercial licenses for the Software covering all workstations that will access the Software through the network. 4. TRADEMARKS AND LOGOS SLIK is a trademark of SLIK Software Ltd. DB Explorer is a trademark. Windows is a registered trademark of Microsoft Corporation. All other trademarks and service marks are the property of their respective owners. 5. GOVERNING LAW Any action related to this License will be governed by New Zealand law. No choice of law rules of any jurisdiction will apply. 6. LIMITATION OF SUPPORT If you are using the Software free of charge under the terms of this agreement, you are not entitled to support or telephone assistance. 7. MULTI-USER packages, company licenses If the copy of the Software you received was accompanied by a printed or other form of "hard-copy" License whose terms vary from this agreement, then the hard-copy License governs your use of the Software. 8. DISCLAIMER OF WARRANTY THIS SOFTWARE AND THE ACCOMPANYING FILES ARE SOLD "AS IS" AND WITHOUT WARRANTIES AS TO PERFORMANCE OR MERCHANTABILITY OR ANY OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED. Because of the various hardware and software environments into which DB Explorer may be put, NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED. Good data processing procedure dictates that any program be thoroughly tested with non-critical data before relying on it. The user must assume the entire risk of using the program. ANY LIABILITY OF THE SELLER WILL BE LIMITED EXCLUSIVELY TO PRODUCT REPLACEMENT OR REFUND OF PURCHASE PRICE. 9. HIGH RISK ACTIVITIES The Software is not fault-tolerant and is not designed, manufactured or intended for use or resale as on-line control equipment in hazardous environments requiring fail-safe performance, such as in the operation of nuclear facilities, air traffic control, aircraft navigation or communication systems, direct life support machines, or weapons systems, in which the failure of the Software could lead directly to death, personal injury, or severe physical or environmental damage ("High Risk Activities"). SLIK Software Ltd specifically disclaims any express or implied warranty of fitness for High Risk Activities. 10. DISTRIBUTION OF EVALUATION VERSION Provided that you verify that you are distributing the evaluation version you are hereby licensed to make as many copies of the evaluation version of this software and documentation as you wish; give exact copies of the original evaluation version to anyone; and distribute the evaluation version of the software and documentation in its unmodified form via electronic means. There is no charge for any of the above. You are specifically prohibited from charging, or requesting donations, for any such copies, however made; and from distributing the software and/or documentation with other products (commercial or otherwise) without prior written permission. 11. QUESTIONS AND SUPPORT Should you have any question concerning this agreement or SLIK Software Limited please contact SLIK Software Limited, P.O. Box 12 238, Thorndon, Wellington New Zealand. Homepage: www.slik.co.nz e-mail: [email protected]