Re: Comparing table structures - Question...

On Tue, 16 May 2000 14:20:10 +0200, Wolfgang Zager <zager@compuserve.com> wrote: >"Stephens, Alan" wrote: >> >> Using Informix Dynamic Server 7.3 on Solaris >> snip >> 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. >> snip >> >> Are there any other neater solutions ? In IIUG archive is dbdiff utility. Compare two databases and create ALTERs... > >Something which works very well for us is to create a table, in which >You store a version number for all Your other tables. >When doing an alter, we first check the stored version number an then >decide which alters have to be done. Every changes that we created save to file with name of number project request. We know what version is where (customer). Then concencate appropriate files and run it in dbaccess. Sorry, my english is ... -- Jiří Lisický ČD DATIS Olomouc e-mail: lisicky@datis.cdrail.cz Nerudova 1 phone: +420-068-472-5496 Olomouc, Czech Republic >>> čeština ISO-8859-2 Compatible <<<