How to get BIDS for Visual Studio 2008 SP1

bidssql-server-2008sql-server-expressvisual-studio-2008

I currently use Visual Studio 2008 SP1 and have been migrating older projects into VS2008 but existing SSIS and SSRS (2005) projects have not been compatible with VS2008. It has been a pain to maintain those BIDS projects as a separate solution.

I have been considering upgrading to SQL2008 but because our dev, test and production platforms are all SQL2005 Enterprise Edition I do not like the idea of deviating my local environment from the current standard. Despite wanting BIDS for VS2008.

I just installed Sql Express 2008 with all the bits and something occurred to me… Did Sql Express 2008 just install all the BIDS bits I need without requiring me to upgrade my local version of Sql Server?

Is this a viable methods of installing BIDS for VS2008 or am I missing something?

UPDATE

I just had a thought… Why don't I just install the tools from the full SQL Server 2008 since I have access to that.

There is still the question of what differences there are between the tools from Express 2008 and the full Sql Server 2008.

Best Answer

BIDS for SQL Server 2005 is based on Visual Studio 2005. AFAIK it won't install directly into VS2008.