Re: Need a tool to compare the structure of objects
Date: 1996/07/14
Message-ID: <31E9B5A1.2502_at_hookup.net>#1/1
Michel Mercier wrote:
>
> Hello.
>
> Does anyone have any suggestions for a tool to compare the structure
> of objects (tables, indexes...) owned by users in an Oracle database.
> I would like to be able to compare the structure of the objects owned
> by differents users (environments...) to make sure they are
> identical....
>
> Thanks!
> Michel Mercier mmercier_at_mediom.qc.ca
You can use any reverse ingeneering tool to export de definition of the tables and indexes and then use any compare utility...
At Sylvain Faust Inc we will have a version of SQL-Programmer for Oracle in September. It can extract any object definition from a server (i.e. Tables, Indexes, SP, Package, ...), we will also have source control built in the tool. With this tool you will be able to do your compare from user to user.
For more detail check the latest news at http://www.sfi-software.com or contact Mike McPhee at mmcphee_at_sfi-software.com.
Marc. Received on Sun Jul 14 1996 - 00:00:00 CEST