install VSTS2008 Database over Developer – missing Database Unit Test Template

Hi *,

I’ve recently installed VSTS 2008 Database edition over my current VSTS 2008 Developer Edition SP1 (on XP) because I want to use the database unit test functionality.  However, the database unit test template is not displayed whenever I try to add a new test to a project.  I only see templates to add a new unit test, ordered test, or use the unit test wizard.  I’ve tried adding tests to a test project and to a database project, but I only get the option of using these 3 test templates each time.

This is very frustrating- I’ve wasted my entire day trying to get it to work, but it doesn’t want to cooperate, nor does there seem to be any useful information on the web.

Thanks, tflop

installation info below:

Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Enterprise

Microsoft Visual Basic 2008
Microsoft Visual Basic 2008

Microsoft Visual C# 2008  
Microsoft Visual C# 2008

Microsoft Visual C++ 2008 
Microsoft Visual C++ 2008

Microsoft Visual Studio 2008 Tools for Office  
Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Studio Team System 2008 Database Edition  
Microsoft Visual Studio Team System 2008 Database Edition

Microsoft Visual Studio Team System 2008 Development Edition 
Microsoft Visual Studio Team System 2008 Development Edition

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V.  All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company.  Electronic version licensed from Lernout & Hauspie Speech Products N.V.  All rights reserved.

Microsoft Visual Web Developer 2008   91901-270-5621473-60931
Microsoft Visual Web Developer 2008

Crystal Reports    AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB945282)   KB945282
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB946040)   KB946040
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB946308)   KB946308
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB946344)   KB946344
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB946581)   KB946581
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB947173)   KB947173
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB947540)   KB947540
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU (KB947789)   KB947789
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB944899)   KB944899
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/944899.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB947171)   KB947171
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947171.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB947180)   KB947180
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947180.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB948127)   KB948127
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948127.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB953256)   KB953256
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/953256.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB971092)   KB971092
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/971092.

Hotfix for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB973674)   KB973674
This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/973674.

Microsoft Recipe Framework Package   8.0
This package provides services to the guidance packages.

Microsoft Visual Studio Team System 2008 Development Edition – ENU Service Pack 1 (KB945140)   KB945140
This service pack is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945140.

Microsoft Visual Studio Team System 2008 Development Edition – ENU Service Pack 1 (KB947888)   KB947888
This service pack is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947888.

Microsoft Visual Studio Team System 2008 Development Edition – ENU Service Pack 1 (KB948484)   KB948484
This service pack is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948484.

Microsoft Visual Studio Team System 2008 Development Edition – ENU Service Pack 1 (KB948560)   KB948560
This service pack is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948560.

Security Update for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB972222)   KB972222
This security update is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/972222.

Security Update for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB973675)   KB973675
This security update is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/973675.

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 10.0.1600.22

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 10.0.1600.22

Update for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB956453)   KB956453
This update is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/956453.

Update for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB967143)   KB967143
This update is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/967143.

Update for Microsoft Visual Studio Team System 2008 Development Edition – ENU (KB972221)   KB972221
This update is for Microsoft Visual Studio Team System 2008 Development Edition – ENU.
If you later install a more recent service pack, this update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/972221.

Visual Studio Package Load Analyzer   1.0
A utility that analyzes package load failures in Visual Studio.

 

Hi Tflop,Thank you for your post.Based on the information of your Visual Studio 2008, it seems that you have not upgraded VSTS2008 Database Edition to SP1.Thus, could you please try downloading Visual Studio 2008 SP1 from http://www.microsoft.com/downloads/details.aspx?FamilyID=27673c47-b3b5-4c67-bd99-84e525b5ce61&displaylang=en and install  it again to update VSTS2008 Database Edition?If it still doen’t work after upgrading, please try devenv.exe /InstallVSTemplates (in Start > Run or “Visual Studio 2008 Command Prompt”) to rebuild the cache since Visual Studio uses a cache on disk of all the installed  project/item templates.Hope this helps! If you have any concern, please feel free to let me know.Best regards,Yichun Chen/

I did try and download the VSTS 2008 SP1 and install  the same also.But not sure about the update VSTS2008 Database Edition? can you please tell what do you mean by this ? Thanks in advance