Re: Best Way to Compare Informix Databases

I select all relevant information out of the systables and syscolumns tables, sort it, and do a diff, it's usually not too bad. This of course ignores indexes and constraints, but the same thing could be done there. You might try sdiff if you don't like diff output. Tim Owens wrote: > What is the best way to compare two informix databases? > > My current approach is to run dbschema on both databases, then diff the output. > > However, since diff only does a line-by-line file comparison, one difference > between the databases causes a domino effect in the line-by-line comparison > of the schema output. > > Does informix have a built-in tool that would provide a better way? > > Any help would be appreciated, > > Tim Owens -- - Danny Wright danwright@ #include <stddisclaimers.h>