Microsoft Visual Studio Team System 2008 Database Edition - complete package

8/10 Microsoft Visual Studio Team System 2008 Database Edition

GregMoxyMedia - 04/03/09

I tried to use Microsoft VS TSF 2008 Database Edition to run Unit Tests on Stored Procedures. I applied both expectedSchemaCondition and checksumCondition as test conditions. To trigger some errors I changed data type of a column from float to numeric(18). The test reported the follovin error: " Expected type System.Double did not match actual type System.Decimal " - not exactly what I expected but it gives some hope that schema missadjustment will be caught. Subsequently I altered in my DB nvarchar(50) to nvarchar(MAX) and I did not get any error. That worries me because I can not trust the tool with size of a field. Could someone refer me to comprehensive literature on what I should and what I should not expect from expected schema and checksum conditions in VS 2008 while accessing SQL Server 2005? Is the tool applicable to other DB? What DB can take advantage of this tool?