Re: How do you guys maintain DDL versions?

My article is in Tech Notes, Volume 3, Issue 4, 1993, actually. Thanks for the plug. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: Jack Parker <jparker@hpbs3645.informix.com> }Date: Mon, 8 Jul 96 19:24:43 MDT }X-Informix-List-Id: <list.10607> } }> [begin rant] }> The best repository for definitions is not in a repository --- it's }> should be the database itself. Anyone remember Dick Pick's philosophy }> in this regard? That's what makes Pick/Revelation developers so loyal; }> you can walk in on *any* running system, and the system itself is its }> own dictionary, easily queried and manipulated *like data*. }> [end rant] } }I use dbdiff2. It reads the definition from two databases and generates }DDL. Of course it doesn't handle saving revisions of that DDL. For that }I would recommend saving off a dbschema each time it mattered. For that }matter you can check out an excellent article on the topic in Informix }Tech Notes - I want to say Vol 4 Iss 1 - but loaned out my copy and }can't remember. Written by none other than our own known and loved J.L. }He also calls out Andy Orams book (O'Reilly - managing projects with make) }which I promptly went out and bought, read and have been savouring ever }since.