Re: Best Way to Compare Informix Databases

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 I'm sorry for multiple posting - I'm not sure that previous message was delivered because of mailer problems. I have my own utility for comparing two dbschema files and generating SQL script to convert one to another. It written on C (gcc for Solaris). I cannot guarantee that my program is error-free but I use it over a year with Informix-Online 7.12 on Sparc. I can give it for public usage/comments/etc... if anyone interested If you want please mail me where I can put it to. Leonid (white@intek.spb.su)