Re: Best Way to Compare Informix Databases

Hmmmm, I see you posted three times, is that like, what I tell you three = times is true,=20 OK. Get ye hence to www.iiug.org Get ye hence to www.iiug.org Get ye hence to www.iiug.org Some smart people have written the very thing you seek to find. Look for dbdiff by Jack Parker and Kerry Sainsbury, inspired by Dave = Synder. rgds Peter Tashkoff <tashkop@iname.com> Zespri International Limited Std Disclaimers Apply All rights reserved. No party may use this document to vilify another. Zespri New Zealand Kiwifruit, The World's Finest >>> "Tim Owens" <towens@bsat.com> 25/03/98 02:11:42 >>> 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.=20 Does informix have a built-in tool that would provide a better way? Any help would be appreciated,=20 Tim Owens