Re:Database Versioning
by cstejerean on Monday March 02, 2009 @09:54PM
(#500985)
I understand that part, that's what I meant about it working in a linear fashion. What happens when two developers both start with schema 104 and develop in parallel? Which one of them becomes schema 105?
Re:Database Versioning
by jasonkester on Monday March 02, 2009 @10:07PM
(#500999)
Ah. Since the scripts are under source control, it's simply a matter of resolving conflicts when you check in.
But then, since you'll generally have a continuous build is running on 5 minute intervals, it's pretty rare to have two independent schema changes in the same script.
Basically, you can know with certainty that you can move from any numbered version to another by simply running the intervening scripts.