Re: Schema comparison

Hi,

This utility came from the archives of the PL/SQL pipeline. The url is http://www.revealnet.com/Pipelines/PLSQL/archives.htm.

Schema Comparison Utility
Author: Tom Niderost (Tom_at_TEMPUS.COM)

I have created a tool called OraCompare that we use in-house for schema comparison. It is a beta product, and it has been posted for free download and use.

OraCompare will compare objects in two different schemas. The schemas can reside on different servers or be on the same database. It has been tested with Oracle 8 and 8i only. At this time it does not compare Types and Type Bodies.

It is designed to run on a Win9x/WinNT/Win2K client. This is a work in progress, and more features will eventually be added.

The application was written in Delphi, with "Direct Oracle Access" components used to communicate directly to the OCI.

Format: Application
http://www.niderost.com/oracompare.exe

"Brian Dick" <bdick_at_home.com> wrote in message news:MBVk6.5392$PR.38664_at_news1.wwck1.ri.home.com...
> We are working on a new version of our database and need a tool that can
> compare the new schema with the current production schema. I would like to
> use the output from the tool to write a script to migrate the production
> schema to the new schema.
>
> Anyone using such a tool?
>
> Later,
> BEDick
>
>
Received on Wed Feb 21 2001 - 21:51:42 CET