how to add source control to sql server 2008?

Question

I'm newbie to TFS it, and i have installed it already. Everything works fine but strangely i find no source control on SQL server management studio 2008 r2 (tools/options) as in the below image

What should i do now ?

Thanks, Nam Vo

Answer 1

You need Team Foundation Server MSSCCI Provider. And then you can add SSMS projects to source control (just like in Visual Studio).

From my experience- working with SSMS and TFS is not very comfortable. Third party tools could be much nicer choice (for example red-gate, although havent really worked with their source control tools).