How to maintain a centralized repository of the db schema and have it under source control
A question on many development projects that use a database is how to share that database with the entire development team and keep up a centralized, version controlled version of the schema which can be easily shared, deployed and maintained. Visual Studio 2010 steps up to the challenge with the database projects. You can easily import existing databases and put them on source control using Visual Studio. To learn more about this please visit the MSDN site: Walkthrough: Put an Existing Database Schema Under Version Control.
You can read more about suggested processes on how to keep up database changes here.