VSS to TFS migration without local SQL Server Express

The VSSConverter is a handy tool if a little light on documentation. I was running into an issue with VSSConverter failing where there was no local instance of SQL Server Express.

The MSDN documentation shed no light. http://msdn.microsoft.com/en-us/library/ms253123%28v=vs.80%29.aspx

After a few moments reflection with a glass of my favourite tipple I resumed attack on this obstacle and discovered it is possible to enter a SQL parameter on the migration settings file as follows:-

<Source name="VSS">

      <VSSDatabase name="D..."></VSSDatabase>

      <UserMap name="..."></UserMap>

      <SQL Server="SQLServerHost" />

</Source>

Job done.