Re: Re: SQL Source Control

2007. 04. 11, szerda keltezéssel 21.43-kor Colin Guthrie ezt írta: > Zoltán Németh wrote: > > yeah I have the same problem ;) > > > > I have two kind of SQL files: > > 1) SQL of the complete, blank DB structure - I store it for each main > > version (I should store it for each version if I wouldn't be so > > lazy... ;) ) > > 2) SQL instructions to upgrade from a DB version to another - I need > > these to upgrade working databases > > > > however I have no real solution for rollback, and if something is broken > > in a new version and I have to revert a working DB to an older state, > > well that's real serious trouble (and usually a lot of cursing and stuff > > like that).... > > > > so, if anyone has a good solution I also would like to hear it :) > > No technical solution, but just put a "Swear Box" in the office and that > way when a borkage happens you'll all have to put a £/$/€ in the tub > with each curse you utter... It wont help but at least come Friday night > you can all enjoy a few extra beers in the pub ;) heh good idea, I think I will implement it in the next version ;) greets Zoltán Németh > > Col >