Database development approach that fits into agile development methodology
Agile development methodology is most popular among the developers. We can also get the advantage of this technology when creating and maintaining a database in SQL Server.
We wanted to store the database project in a source control system. Every official version of the database project must be in Source Control and in a manner that made it very easy to establish which scripts we required for which build, and in which order we needed to apply them. We wanted to banish forever the days when we'd need to search around in Source Control - or worse, on the developer's machine - for the correct files.