I’ve been following Visual Studio Database Edition (VSDB) aka Data Dude, since the initial release over two years. The best overview of VSDB I’ve seen recently is a presentation
given by Gert Drapers at PDC2008. Until recently I’ve only been able to look at the product from a distance attending several presentations at various SQL Server conferences, but never able to install it because of the steep licensing costs. In October, 2008, Microsoft announced a change in licensing terms
providing VSDB with certain MSDN licenses including my own, so I proceeded to download and install VSDB.
Since I already had Visual Studio 2008 Professional Edition installed I grabbed the "Visual Studio Team System 2008 Database Edition" from my MSDN and proceeded to install and did not encounter any issues. I then fired up Visual Studio 2008 to create a Database Project and quickly noticed the options available did not look the same as the PDC2008 presentation
"Visual Studio Team System 2008 Database Edition GDR does not apply, or is blocked by another condition on your system. Please click the link below for more details."
So, maybe I didn’t have VS SP1 installed afterall. I then installed Visual Studio 2008 SP1
and did not encounter any problems. The installation however did ask for the media for VSDB, but not for VS Pro. With SP1 installed I was able to install VSDB GDR and my project options looked correct:
In summary to install VSDB 2008 you must:
- Install Visual Studio 2008 Database Edition
- Install Visual Studio 2008 Service Pack 1
- Install Visual Studio 2008 Database Edition GDR
Note: Step #1 and #2 are intechangable, but this is not how I installed VSDB.
Lesson Learned: Although the installation of VSDB is not intuitive, carefully reading the installation instructions would have saved me several hours of frustration!
This post helped me find a resolution.