In addition to the other suggestions, use Qedit (or another editor) to
remove the lines you do not want to compare first. During Y2K, I compared
hundreds of databases using the method.
1. Use Adager "Schema" command against the master database to get a known
good schema in a specific, consistent format.
2. Use Adager "Schema" command to get schemas for all databases to compare.
3. Use Qedit to remove all lines which I expect to be different from all the
files. Capacity lines, date lines, etc. Leaving only the actual database
structure in the files to compare.
4. Use Robelle QCompare to compare the resulting files.
> -----Original Message-----
> From: Kundl, Eric [SMTP:[log in to unmask]]
> Sent: Thursday, November 20, 2003 3:02 PM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] comparing Image Schemas
>
> Thanks for the suggestions.... But we have about 120 databases that need
> to be compared for differences from a defined schema.
>
> I was hoping there would be something that would compare the database to
> a 'master' schema file and report the differences.. Maybe with this many
> database it would be worth the time to write something.
>
> -------------------------
> thanks,
> Eric Kundl
>
> Navitaire
> 6322 South, 3000 East, Suite 150
> Salt Lake City, UT 84121
> Tel: 801-947-7891
> email: [log in to unmask]
>
>
> -----Original Message-----
> From: Keven Miller [mailto:[log in to unmask]]
> Sent: Thursday, November 20, 2003 1:52 PM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] comparing Image Schemas
>
>
> if you have the tools,
> I use Adager to create the schemas, so they are more consistent. Then
> compare from Robelle to compare the files.
>
> You will get the capacity lines listed, but thats easy to get used to.
>
> ___________________________________________________________________
> Keven Miller mailto:[log in to unmask] http://www.exegesys.com
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
############################################################################
#########
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
############################################################################
#########
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
