Running VSSConverter Against SQL Server 2005

The VSSConverter tool which allows you to convert from VSS to TFS will attempt to utilize a local version of SQL Express.

This sucks, as I hate SQL Express.

After some searching/trials/errors, I found a way to get it to work against a SQL Server 2005 database.

Just add the SQL tag to your migration settings xml file like so:

<Source name=VSS>

      <VSSDatabase name=D:Program FilesMicrosoft Visual SourceSafeVSSHttp></VSSDatabase>

      <UserMap name=D:VSS2TeamFoundationUsermap.xml></UserMap>

      <SQL Server=name_of_your_SQL_Server />

</Source>

Unit testing data access

Roy Osherove blogs that he was mistaken when he suggesting using mocks for data access code.  With the improved Rollback attributes that he helped create, along with people like Justin Burtch who created a similar attribute for VSTS, they are now thinking that this is the way to go: rolling back database changes.

Roy is no fan of VSTS testing, finding a few bugs and some questionable design decisions.  Those don’t seem like deal breakers for me, but we will see.