Re: Best Way to Compare Informix Databases

This is a multi-part message in MIME format. --------------23287AC8B8EDE9F0CCB8ABA7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit With ERWin you could compare model-to-database, model-to-script and vice versa. It generates the DDL sentences to apply the changes in both ways! Check it out! 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 --------------23287AC8B8EDE9F0CCB8ABA7 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Melvin Perez Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Melvin Perez n: Perez;Melvin org: CAM Informatica. S. A. email;internet: cam@codetel.net.do title: Technical Vicepresident tel;work: (809) 686-5574 tel;fax: (809) 686-5467 tel;home: (809) 227-2893 x-mozilla-cpt: ;-960 x-mozilla-html: FALSE version: 2.1 end: vcard --------------23287AC8B8EDE9F0CCB8ABA7--