source control

SQL Server Database Project and Database Source Control

Submitted by Ben Hodson on Wed, 07/13/2011 - 15:25

One the features long sought after by developers is a reliable and easy way to maintain source control on SQL Server databases. Especially on Agile projects where multiple developers are making changes to a database schema at the same time, database source control is an absolute necessity.

Fortunately, Microsoft now provides a tool to synchronize schema changes across databases and store the change history in source control. This tool is availble in Visual Studio 2010 and is called the SQL Server 2008 Database Project.