Comparing two informix databases

Is there a tool for comparing two informix databases. I want to know, if there is a difference on tables, stored procedures or triggers between my local database and a database installed on an other machine. Is there an other tool for bringing the second database to the same status as the first? One possibility for comparing two databases is to create 2 files with dbschema and compare the 2 files. So I can see the difference between the 2 databases. Is there a more comfortable tool? Thanks for any help Edmund Schöpf

DBCompare will compare the table structure but not stored procedures and triggers. http://www.automatedofficesystems.com/products/dbcompare/ David In article <374D5910.53312D5@netscape.net>, edmundschoepf@netscape.net wrote: > This is a multi-part message in MIME format. > --------------C195A547C993AE8AEE6D67D2 > Content-Type: text/plain; charset=iso-8859-1 > Content-Transfer-Encoding: 8bit > > Is there a tool for comparing two informix databases. I want to know, if > there is a difference on tables, stored procedures or triggers between > my local database and a database installed on an other machine. > Is there an other tool for bringing the second database to the same > status as the first? > One possibility for comparing two databases is to create 2 files with > dbschema and compare the 2 files. So I can see the difference between > the 2 databases. > Is there a more comfortable tool? > > Thanks for any help > Edmund Sch'pf > > --------------C195A547C993AE8AEE6D67D2 > Content-Type: text/x-vcard; charset=us-ascii; > name="edmundschoepf.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Edmund Sch'pf > Content-Disposition: attachment; > filename="edmundschoepf.vcf" > > begin:vcard > n:Sch'pf;Edmund > tel;home:http://www.freewebinfo.com > x-mozilla-html:FALSE > adr:;;;;;; > version:2.1 > fn:Edmund Sch'pf > end:vcard > > --------------C195A547C993AE8AEE6D67D2-- > > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.