How to store the stored procedures in TFS

Question

HI all,

Iam using VS2008 and SQL2008 i want to access my stored procedures in VS2008 TFS so please tel me the steps to do it.

Thanks in advance

Answer 1

Use the GDR R2 project: Microsoft® Visual Studio Team System 2008 Database Edition GDR R2

If you don't have Team System, then use the built-in database project.

Handling Database easily with Visual Studio 2008

Answer 2

I usually have Database project stored inside my source control repository that contains all the scripts necessary to create a new database, all the tables, views , sp's etc.

Generating scripts for SP's is quite easy. Simply open up the Server Explorer and connect to you database, sekect any existing sp and drag it onto the database project in the project browser window.