Schema Comparison 3.0.2 90-Day Trial Version

Hi All,

You can download Schema Comparison 3.0.2 90-Day Trial Version at

http://protasov.simplenet.com/

                Properties

Schema Comparison 3.0 is shareware utility aimed to compare and synchronize two Oracle database schemas. These are main features of the program:

It compares tables, indexes, constraints, sequences, synonyms, roles, comments, triggers, views, procedures, packages and privileges. Only objects with differences are shown.

Schemas are defined by appropriate user names. They can be located in the same ore in the different databases. In the last case program uses database link to get access to the remote schema.

Utility can synchronize definitions of constraints, comments, triggers, views, procedures and packages. This is implemented by retrieving definitions from the source schema and applying them to the target. One can copy all or only single object to the destination.

The synchronization can be bi-directional: you can copy some objects from the first schema to the second and others in the backward direction. This is very helpful when your have more than one development database.

The application can compare and synchronize table contents. Tables must have the same names and identical structures. Synchronization is based on the information about unique keys. Records with new keys are inserted and those with existing keys are updated.

Search condition entry fields are widely used to limit data processing amount. Prefix search is the most popular in the software. This capability is very helpful when working with large schemas.

There are a lot of other useful features such as editing tables and views, updating comments, compiling schemas, revoking privileges, enabling and disabling constraints and triggers.

Utility user must have DBA privileges because program actively uses information from SYS.DBA_ views and accesses objects in another schemas. Usually I create one special user with DBA privileges for this purpose.

Program creates some additional tables in the connected user's schema during startup and drops them before exit. They can be left in the schema if connection to the server was lost or process was killed.

This software works in Windows 95/NT environment. It has simple setup which registers program, inserts it's icon in the program menu and creates folder. Utility has simple multi-window interface with wide usage of data grids.

Application is developed in Delphi 3.0 and uses Direct Oracle Access 2.31 components to communicate with Oracle software. It is implemented as a single exe-file, which directly calls ociw32.dll or ora7x.dll. There are no any needs to setup or configure IDAPI or ODBC software.

Utility is shareware with 90-day trial period.

                Hardware and Software Requirements

The software is intended to work in such environment:

486 or better standard PC;

10 M of RAM only for the application (without OS or other programs' requirements);

5 M of HDD storage for the program;

800*600 or better screen mode (large fonts are preferred);

Windows 95/NT 4.0;

Internet Explorer 3.0 or Netscape Navigator 3.0;

Oracle client software for Windows 95/NT;

Oracle RDBMS 7.x or Oracle RDBMS 8.x (with version 7 catalog support enabled);

Local area network supported by Oracle.

                                            Andrew Protasov