Re: Comparing table structures - Question...

From: "Stephens, Alan" <alans@credo.ie> > >Using Informix Dynamic Server 7.3 on Solaris > >I have an installation procedure for my software which at the moment >isnt >very intelligent. Each patch has to contain any alterations to the table >structures needed. Then every few mths I have to ammalgamate all >of those alter scripts into one for simplicity. > >What I want to have as part of my install, is a way of comparing the >structure of each table on the customers database with the latest >structure in the install, and if necessary alter the table structure on >the fly. > >I figure this is possible and somebody has probably done it before. >Presumably one way would be to run dbschema -d databasename -t tabname >, parse the table structure, compare it with my uptodate table >structure, and alter >it if necessary. However, this sounds like a very complex and >troublesome task. > >Are there any other neater solutions ? I'm pretty sure there are a couple at http://www.iiug.org in the software section. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com