Re: SQL Source Control

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 ;) Col