Re: Informix Question (fwd)

> > rnyapath@bass.cis.ufl.edu (Ramana Nyapathi) wrote: > > Use the "dbschema" utility, which writes the schema to a specified > file. Once the schemas are in files, one can run an unix utility like > "diff". > > The nice thing about "dbschema" utility is that, it you can determine > the schema level, table, whole db etc.. The bad part is that it also > lists the privilages and ownerships of tables and other objects. > The other bad part is that there is no gaurantee that the tables were created in the same order in the two databases or that the indices were created with the same names. In other words the diff would report some wild stuff. dbdiff2 handles the first of these nicely and the second most of the time. You can find it at the archives (ftp.mathcs.emory.edu/pub/informix/dbdiff2.sh) cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________