Re: New Schema Comparison 3.2 with SQL repository and Table Copy 1.1

I do not want to be a kill joy, but Oracle themselve supply a very similar product with enterprise manager : Change Management Pack.

Regards
David Russell

protasov_at_percombank.kiev.ua wrote in message <6t97sd$lde$1_at_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 - 15:56:57 CDT