Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is there integration of TFS 2008 source control with SQL Server 2008 Management Studio / Client tools for Database versioning??? Expand / Collapse
Author
Message
Posted Friday, November 20, 2009 12:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 12, 2010 1:13 PM
Points: 1, Visits: 11
Hi,
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.

Thanks,
Ravi
Post #822607
Posted Friday, November 20, 2009 12:20 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 2:32 PM
Points: 3,428, Visits: 14,439
You are missing the GDR2 download and install when you install it you will see SQL Server 2005 and 2000 for development but at the point of connection VS2008 still shows only 2008 you have to manually remove 2008 before you will see 2005 in the drop down if you have 2005 running. It just takes some helping.

http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en





Kind regards,
Gift Peddie
Post #822628
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse