VSDB 2008 Version Numbers
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:
| 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: https://dbproj.com/Tutorials/tabid/62/TID/17/cid/2/Default.aspx