Go through the following link to see how we can use a visual studio database project to manage db scripts and collaborate with this to source controlled db management.
http://peterkellner.net/2009/01/17/visual-studio-database-edition-review-sqlserver2008/
Microsoft® Visual Studio Team System 2008 Database Edition GDR R2
Instructions
Note: You must install Visual Studio Team System 2008 Database Edition or Visual Studio Team System 2008 Team Suite before you install the power tools for the Database Edition.
You can find documentation for Database Edition as part of the online MSDN Library. In addition, you can install the documentation on your local computer from the most recent release of the MSDN Library.
Microsoft® Visual Studio Team System 2008 Database Edition Power Tools
Instructions
Install
Localized versions of the GDR for Visual Studio Team System 2008 Database Edition will be available in the same languages as Service Pack 1 for Visual Studio 2008 (SP1). Each language-specific version of Database Edition must be installed on a version of Visual Studio 2008 SP1 that is running the same language. For example, the French GDR for Database Edition must be installed on a French version of Visual Studio 2008 SP1. If you would like to install a non-English version of the GDR for Database Edition, replace “English” with your language choice in the following instructions.
1. Install Microsoft® Visual Studio Team System 2008 Database Edition SP1 (English) or Microsoft® Visual Studio Team System 2008 Suite SP1 (English)
2. Uninstall the Database Edition Power Tools if installed. To uninstall the Power Tools from the command line, use: msiexec /X {EA016DAB-E08A-46FB-BBF0-ED6EB8FD4671}
3. Uninstall any previous version of the GDR for Database Edition. To uninstall a previous version of the GDR from the command line, use: msiexec /X {DDF197C6-4507-3A19-A4B5-0E17CC931370}
4. Install Microsoft® Visual Studio 2008 Service Pack 1
5. Install Visual Studio Team System 2008 Database Edition GDR by running the self-extracting executable SETUP.EXE.
