Best practices to Manage Database project in TFS and visual studio

Question

Currently , we don't have our stored procedures , and everything else related to the proj in TFS , we are managing everything on Server ( Adding , Fixing , removing stored procedured , tables etc) We would like to start manage everything via tfs and visual studio.

Is there any best practices on how to manage this stuff ? I didn't read about Sql Server 2005 Visual studio template and doesn't know what it does , but is there any way to create a project in VS , connect to existing DataBase , and be able to track changes of procedures , in TFS ?

Thanks.

Answer 1

Yes, you can create a database project and import objects from the database you want to manage. You can start with this MSDN article.