VSS to TFS Migration without SQL Express

I am finishing up a new TFS implementation at my current client. They are migrating their code from VSS. VSSConverter.exe needs a SQL Server database to perform some of the intermediate steps before getting the data over to TFS, the problem is that the converter defaults to a SQL Express database, which would be great, except that I don’t have Express installed on my laptop. MSDN tells me what to do to change this behavior, but they don’t tell me when I need to add that XML element. So after messing around with it, I found that I need to add it to the “Source” section of my Settings.xml file, so it would look like this:

  1. <Source name=VSS>
  2. <VSSDatabase name=c:\VSS>VSSDatabase>
  3. <UserMap name=C:\VSS Migration\Usermap.xml>UserMap>
  4. <SQL Server=.>SQL>
  5. Source>

About esteban

Esteban is the Founder and Chief Technologist at Nebbia Technology, an ALM consulting and Azure-powered technology company. He is a software developer with a passion for ALM, TFS, Azure, and software development best practices. Esteban is a Microsoft Visual Studio ALM MVP and ALM Ranger, Pluralsight author, and the president of ONETUG (Orlando .NET User Group).

One thought on “Error when installing SQL 2008 on Windows Server 2008 R2 (64 bit)

  1. Mark Allen

    Another approach which works well is to have the XML tag reference a custom TFS group. In my case there is a master contributor group shared between projects so rather than list all the contributor users in the template AssignedTo list boxes I created a TFS group called ‘TeamAssignments’ and within security I referenced the team. Then in the templates I added the tag ListItem value=[project]\TeamAssignments. Now when anyone is added to the team they are displayed in the AssignedTo List box. This also means that another team can be created without changing the templates as the changes can be done in security.

    TFS Team Name: Blue (example set up in security)
    TFS Group Name: TeamAssignments
    Members: Team Blue

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? *