Re: Schema comparison

I have encountered some situations where it is necessary to keep track of schema changes. Particularly during development, or where the application is DYNAMIC. i.e. the users can specify their own tables and formats. In such situations keeping track of the changes can be necessary. > > I heard that there maybe a way in cron to diff schemas > > every night for changes. > > I am not sure if it is a shell script or something Informix has > > available. > > It is trivial to write a shell script to perform this task: > mv schema_filename old_schema_filename > dbschema -d dbname schema_filename> diff schema_filename old_schema_filename | mail yourname > > It may not be trivial to manage a database where just anyone can > make schema changes on a daily basis, especially without you! Have > you some special requirement for this? We try to let the DBA make > all these changes, as altering a table can have dire consequences if > done wrong. > > Be careful, > __________________________________________________________________ > | Clem Akins Standard Disclaimers Apply | > |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | > | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | > |________________________________________________________________| Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc