I am using TFS 2008 (which uses SQL Server 2005 behind the scenes for storing source control files). I have installed the MSSCCI provider for TFS 2008. I have installed this to test the use of third party commerical product (Red Gate's SQL Compare) with TFS 2008 for database versioning. This product allowed me to do two things - 1. Script my database objects and store them (as scripts) in TFS source control 2. Script the changes done to database and update the scripts stored in TFS source control (in Step 1).
I read in one blog that using MSSCCI provider for TFS 2008 and SQL Server 2008 Management Studio / Client tools, I could do same functionality or more. Is that correct? I don't see that integration when using MSSCCI provider for TFS 2008 with SQL Server 2005 client tools. Did I miss something?
Please advise. Reply soon.