Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> New Schema Comparison 3.2 with SQL repository and Table Copy 1.1

New Schema Comparison 3.2 with SQL repository and Table Copy 1.1

From: <protasov_at_percombank.kiev.ua>
Date: Thu, 10 Sep 1998 19:04:45 GMT
Message-ID: <6t97sd$lde$1@nnrp1.dejanews.com>

Hi All,

New Schema Comparison 3.2 with SQL repository and Table Copy 1.1 are available at

http://protasov.simplenet.com/

                 Features

Schema Comparison 3.2 is 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 or in the different databases. In the last case program uses database link to get access to the remote schema.

Utility can synchronize definitions of tables, indexes, sequences, 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. You can disable error messages to speed up synchronization and compile schema after this process. Program can copy definitions of tables and indexes with or without storage parameters. It is possible to do a complete synchronization of all definitions in two schemas by pressing one button only.

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 schema.

There is a drop object feature in order to drop tables, indexes, constraints, sequences, synonyms,  triggers, views, functions, procedures and packages. It is possible to drop all objects in the schema by pressing one button. You should be very careful when using these features because it is very easy to lose critical production data. 

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

Extendable repository of SQL and PL/SQL statements contains many useful queries with variables to view state of the Oracle instance. Query results can be browsed in a table grid and sorted on any column. Error position in the source text is indicated by the cursor. You can specify time refresh interval for any statement. It is possible to save the repository contents to a file and load it from the file.

Search condition entry fields are widely used to limit processing data. 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 temporary 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 session was killed.

This software works in Windows 95/NT environment. It has simple setup which registers program, inserts its 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 4.0 and uses Direct Oracle Access 3.1 components to communicate with Oracle software. It is implemented as a single exe-file, which directly calls ociw32.dll, ora7x.dll or ora8x.dll. There are no any needs to setup or configure IDAPI or ODBC software.

Utility has 90-day trial period.

Andrew Protasov

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 10 1998 - 14:04:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US