Re: How do you guys maintain DDL versions?

> > [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. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________