How to manage and capture database changes across several developers?
- by Matt Greer
We have three developers and one tester all working against the same database. We change the schema of the database quite often, and every time we do it tends to have a ripple effect of headaches for everyone else.
Are there good practices in place for .NET oriented development against MS SQL Server 2008 for managing this? I am thinking something similar to Rails Migrations and each dev and tester has their own local database. Or is that overkill? It'd at least be nice to have separate test and dev databases, but currently manually keeping two databases in sync is probably worse than our current predicament.
LiquiBase seems promising, has anyone successfully used it in a similar environment? Or are there better approaches?
We are using SQL Server 2008, VS 2008 and .NET 3.5 if that matters at all.