utility to compare databases...

Hi, Anybody written any utility to compare two database structures for added/dropped/altered columns, data types, constraints..etc. I am trying to synchronize development database with production. Thanks in advance Prasad pmahale@yahoo.com ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Prasad Mahale wrote:, > Anybody written any utility to compare two database structures for > added/dropped/altered columns, data types, constraints..etc. > I am trying to synchronize development database with production. DBDIFF2 in the IIUG Software Archive -- http://www.iiug.org/ -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

Prasad Mahale wrote: > > Anybody written any utility to compare two database structures Several people have recommended looking at dbdiff2.4gl in the IIUG Software Repository, which is probably the tool of popular choice. The current state of dbdiff2.4gl is somewhat fractured, in that there are several versions around. The copy at www.iiug.org is dated October, 1999. In April of this year, I received a copy from Bryan Tonet <bryan@printman.com.au>, who said he had found and fixed a few bugs. Around that same time, I also heard from David Williams of Informix FAQ notoriety saying he also had a new version at "http://www.smooth1.demon.co.uk/dbdiff2.4gl";. Since that time, the pedestrian though necessary demands of gainful employment have drawn my attention elsewhere, so I haven't had a chance to try to reconcile Bryan's and David's copies with that in the archive. If anyone would like to take a crack at it, let me know. Thanks, Walt. -- Walt Hultgren Software Repository Administrator International Informix Users Group Mailto:software@iiug.org -- HTTP://www.iiug.org/