Re: Best Way to Compare Informix Databases

In article <6f8ded$hr4$1@news.xmission.com>, Tim Owens <towens@bsat.com> writes > >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. 'sdiff' is better than 'diff' and will manage to realign itself after one different line. I normally use it on source code (sdiff -w80 -s file1 file2) but I'm sure it would work great on dbschema outputs. > >Does informix have a built-in tool that would provide a better way? > >Any help would be appreciated, > >Tim Owens > -- Surfer! http://www.nevis-vieww.demon.co.uk http://www.nevis-vieww.demon.co.uk/flash Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.