Many developers will want to install SQL Server 2005 Developer Edition and Visual Studio 2005 on the same PC. (Note: This applies to any version of SQL 2005.) If you install SQL 2005 first and choose to install the BI Development Studio, you are actually installing a stripped-down version of Visual Studio 2005 called Visual Studio 2005 Premier Partner Edition.

You’ll find when you run the Visual Studio 2005 install that you are unable to change the install path. The help will tell you it’s due to dependencies on VS 2005 Premier Partner Edition, but doesn’t indicate how or where you got that. Now you know!

It’s also interesting to note that SQL 2005 includes no less than three variants of the Visual Studio 2005 IDE codebase. One is SQL Server Management Studio, another is the Database Engine Tuning Advisor and the third is the aforementioned VS 2005 Premier Partner Edition. At some point in the VS 2005 development cycle, the SQL 2005 group took a cut of the IDE code and made it their own. The most similarities are in Management Studio, but if you compare it with the VS 2005 IDE you’ll notice slightly different menu items and behaviors.

I assume that the development groups had a good reason (release date??) to diverge these huge IDE codebases, but it seems like they created a mess for themselves.

%d bloggers like this: