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:
Microsoft Visual Studio 2008 Version 9.0.21022.8 RTM
Microsoft Visual Studio Team System 2008 Database Edition
Microsoft Visual Studio 2008 Version 9.0.30729.1 SP
2008 SP1 + GDR
Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.31124.01
2008 SP1 + GDR R2
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.
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ Microsoft.VisualStudio.TeamSystem.DataPackage.dll
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ Microsoft.VisualStudio.Data.Schema.Project.dll
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