|
|
DB Explorer
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.
Keywords: database utility compare database view database database difference schema metadata compare tables compare data compare records synchronise database compare two database schemas table data report differences sync professional flash iso 9000
|
|
|
ODBC View
ODBCView is a free SQL query tool that allows you to view and export data from any OBDC compliant database. Connect to an ODBC data source and enter a SQL statement to execute. Any resulting data is displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statement can be executed including UPDATE, DELETE and calls to database procedures. You can also run it from the command line to open a data source, execute a sql query from a sql script file and export the results to an external CSV or HTML file. The program is completely standalone with no other dependent DLL's other than standard Window system DLL's.
This program is provided free of charge by SLIK Software Ltd as a gesture of goodwill and to encourge users to visit our web site (www.slik.co.nz) for other database related products including DBExplorer (compare and synchronise databases) and Standard Legacy Interface Kit a middleware / automation application that supports column mappings, e-mail, FTP, EDI, XML and 20 other data interfacing operations.
Keywords: database odbc sql sql query tool view data export data odbcview free sql query tool view export data obdc database gps coordinates audit feature
|
