Everything you want to know about Visual Studio ALM and Farming
Brian Harry is a Microsoft Technical Fellow working as the Product Unit Manager for Team Foundation Server. Learn more about Brian.
More videos »
You may have noticed that SQL 2008 SP1 was recently released. I've seen a flurry of questions about whether or not TFS 2008 SP1 will work with SQL 2008 SP1. The good news is that the answer is yes. The bad news is that there's a work around you may have to do to get it to install. The problem has to do with version checks that the TFS installer does to ensure the SQL version is compatible. The checks are too restrictive and even though it will actually work, the installer will tell you the SQL version is incompatible.
Because of the nature of the problem, the install order matters. If you already have TFS 2008 SP1 running with SQL 2008, and you want to upgrade SQL to 2008 SP1, that will just work - because you aren't running TFS setup where the block happens. If, on the other hand, you want to install TFS 2008 SP1 using an already installed SQL 2008 SP1 server, you will need to modify an XML file to get around the block.
The process has been documented in this KB article.
Brian
PingBack from http://asp-net-hosting.simplynetdev.com/using-sql-2008-sp1-with-tfs-2008-sp1/
Thanks Brian -
What I'd really like to know is, can you use SQL Management Studio (SQL 2005 or SQL 2008) with TFS version control in order to check in SQL scripts into source control seamlessly. Or are we limited to using VSTS DB Edition? If it's the latter, where can I find some more reference material, webcasts, etc. on this topic?
Matt: Sort of. If you install the MSSCCI provider for TFS, you'll have TFS source control integration in SSMS. It's not as nice as the Team Explorer integration in VS, but it does work.
That's what I was going to say :) You can get the TFS MSSCCI provider here: http://www.microsoft.com/downloads/details.aspx?familyid=FAEB7636-644E-451A-90D4-7947217DA0E7&displaylang=en
And if you really want to up your game with respect to database development then DBPro is definitely the way to go. Check out http://blogs.msdn.com/gertd - Gert has a ton of great information on his blog, including links to webcasts. I have been using DBPro for a personal project a lot over the last few weeks and it's become my best friend. :-)
The Accentient Blog on Microsoft (Team System) makes it to the upper-right (leaders) quadrant Brian Harry
This just spent me couple hours to find out, that you won't be able to install TFS 2008 SP1 on SQL Server
What do you think is the best approach of upgrading TFS Data tier from SQL 2005 to SQL 2008,as this a part of of our upgrade from TFS 2008 to TFS 2010
Hi Ismail,
Some good guidance for upgrading SQL 2005 to 2008 can be found here: http://msdn.microsoft.com/en-us/library/ms144267.aspx
I would upgrade to SQL 2008 first, make sure TFS 2008 is working properly, then upgrade to TFS 2010. Some good guidance on upgrading TFS 2008 to SQL 2008 can be found here: http://geekswithblogs.net/etiennetremblay/archive/2008/08/11/sql-2008--tfs-2008-sp1-the-lowdownhellip.aspx
If you have any questions, you can feel free to send me a personal question via my blog http://blogs.msdn.com/ablock.
Thanks,
--Aaron