Search This Blog

June 29, 2008

SQL Server 2008 RC0 BIDS and SQL Server 2005 BIDS can do the side by side install

This Feb, I wrote an article (Installing SQL Server 2008 BIDS (CTP6)) about SQL Server 2008 BIDS (CTP6) and got the important result as follows:

Either SQL Server 2008 BIDS or SQL server 2005 BIDS is allowed when you do the side by side install of SQL Server 2008 and SQL server 2005.

Some days ago, I installed SQL Server 2008 RC0 on my Windows XP machine with SQL Server 2005 (full install) and VSTS 2008 .

I find SQL Server 2008 RC0 BIDS and SQL Server 2005 BIDS can do the side by side install. The result is very different from the one in SQL Server 2008 CTP6.

Per msdn, SQL Server Management tools include the following components:

SQL Server Management Studio

SQL Server Profiler

SQL Server Database Tuning Advisor

Command prompt tools, such as sqlcmd.exe and osql.exe.

Business Intelligence Development Studio add-ins to Microsoft Visual Studio

Note that Business Intelligence Development Studio is a separate option during SQL Server installation.

Regardless of how many instances of SQL Server, Analysis Services, or Reporting Services are installed on a computer, only one copy of SQL Server 2008 Management Tools will be installed.

SQL Server 2008 Management Tools can run side-by-side on the same computer with earlier versions of SQL Server Management Tools.

SQL Server 2008 BIDS is really an interesting issue and I don’t know if it will be changed in the version of SQL Server 2008 RTM.

No comments: