Re: Informix Question

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. - Sarat >I am posting this on behalf of a friend. He does not have access to the >newsgroups. Please email your responses to rgoyal@fivepaces.com >-------------------------------------------------------------------------- >Informix experts, > I am faced with a situation to be able to compare two database schema's to >see if they are the same and if not what are the diffrences. I am working >with informix (on-line) 7.1. > Does anybody know of a utility existing which would do the stuff. I am sure >someone was sometime faced with this situation. > More details: On Why I need to compare: >We apply sql scripts to upgrade our products database to latest level. We >also release a schema with each release. >The schema that is released(new installations) is always correct but the sql >scripts that are released alongwith for the upgrade, are sometimes inadequate. >To provide a check against inadequate sql scripts released for upgrade, I >wannted to use the released sql's to upgrade a test DB and then compare it with the dbschema released. >Please reply to >rgoyal@fivepaces.com >thanks in advance >Rajiv Goyal