We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual Studio shell (devenv.exe). Alternatively you can copy the information to the clipboard using the “Copy Info” button.

 

When you are on the latest versions it should look like this:

image

 

Release Visual Studio version information Database Edition version information

2008 RTM

Microsoft Visual Studio 2008
Version 9.0.21022.8 RTM

Microsoft Visual Studio Team System 2008 Database Edition

2008 SP1

Microsoft Visual Studio 2008
Version 9.0.30729.1 SP

Microsoft Visual Studio Team System 2008 Database Edition

2008 SP1 + GDR

Microsoft Visual Studio 2008
Version 9.0.30729.1 SP

Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.31124.01

2008 SP1 + GDR R2

Microsoft Visual Studio 2008
Version 9.0.30729.1 SP

Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.40413.00

As you can see, the RTM and SP1 releases, before the GDR, do not show a separate version number for the Database Edition. This is because they are an integral part of the Visual Studio 2008 release, so they inherit the version numbering from that release.

 

An other method is to look at the file version information of the package that loads Database Edition in to the Visual Studio shell.

Release File name File version

2008 RTM

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
Microsoft.VisualStudio.TeamSystem.DataPackage.dll

9.0.21022.8

2008 SP1

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
Microsoft.VisualStudio.TeamSystem.DataPackage.dll

9.0.30729.1

2008 SP1 + GDR

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
Microsoft.VisualStudio.Data.Schema.Project.dll

9.1.31124.01

2008 SP1 + GDR R2

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\
Microsoft.VisualStudio.Data.Schema.Project.dll

9.1.40413.00

Please note that the file location changed between RTM and the GDR release. RTM and RTM+SP1 Database Edition files are installed in the “C:\Program Files\Microsoft Visual Studio 9.0\DBPro\…” directory, while the GDR and GDR+R2 bits are installed in the “C:\Program Files\Microsoft Visual Studio 9.0\VSTSDB\…” directory. When you install the GDR release the DBPro directory is not removed.

Also note that the file names were changed to reflect the underlying namespace name changes from Microsoft.VisualStudio.TeamSystem.Data* to Microsoft.VisualStudio.Data.* and Microsoft.Data.Schema.*. The first group Microsoft.VisualStudio.Data.* are the files which are Visual Studio specific, the second group, Microsoft.VisualStudio.Data.* are host agnostic. The second naming convention in the GDR is to indicate if a file is provider agnostic or not. Microsoft.VisualStudio.Data.Schema.Project.dll is provider agnostic and Microsoft.VisualStudio.Data.Schema.Project.Sql.dll is provider specific.

Also published on: http://dbproj.com/Tutorials/tabid/62/TID/17/cid/2/Default.aspx