Install Business Intelligence Development Studio 2008

April 4, 2015
BIDS for SQL Server 2012 Setup

Business Intelligence Development Studio is a Microsoft Visual Studio 2008 environment with enhancements that are specific to SQL Server 2008 business intelligence solutions. Use Business Intelligence Development Studio to develop reports and report models in SQL Server 2008 Reporting Services. When you install Reporting Services, the following project templates are made available in Business Intelligence Development Studio:

  • Report Server Project
  • Report Server Project Wizard
  • Report Model Project

Business Intelligence Development Studio also provides an environment for running Report Designer and Model Designer. These are the design tools that you use to author the reports and models in Reporting Services.

When you open a Business Intelligence Development Studio project or designer, you will see project-specific menus in Visual Studio. In addition, the Visual Studio menu options and shortcut menus change to reflect both the project type that you are creating and the specific items that you are working with. As you explore Business Intelligence Development Studio and the Reporting Services features discussed in this topic, you can right-click on various items to learn about these options.

If you have used SQL Server Reporting Services before, you will probably be familiar with the Visual Studio functionality in Business Intelligence Development Studio. If you have not worked with Reporting Services before, this topic helps orient you to the projects and menus in Business Intelligence Development Studio that are specific to Reporting Services.

SQL Server Business Intelligence Development Studio, the 32-bit development environment for Report Server and Report Model projects, is not designed to run on Itanium-based computers and is not installed on Itanium-based servers. However, support for BI Development Studio is available for x64-based computers.

The following table describes the supported versions for authoring and publishing reports in Business Intelligence Development Studio.

Project or File type

Version

Author Reports

Publish Reports

Notes

Report Server Project

or

Report Server Wizard Project

SQL Server 2008

2008 RDL schema

SQL Server 2008 Reporting Services report server only

Upgrades 2003 RDL and 2005 RDL to the 2008 RDL schema locally.

SQL Server 2005

2005 RDL schema

SQL Server 2005 or SQL Server 2008 Reporting Services report server

SQL Server 2000

2003 RDL schema

Not supported

Visual Studio RDLC Report Designer

Visual Studio 2005

Visual Studio 2008

Does not support 2008 RDL schema.

Source: technet.microsoft.com
INTERESTING FACTS
INTERESTING VIDEO
Business Intelligence Development Studio Overview - SSAS
Business Intelligence Development Studio Overview - SSAS ...
Exploring Business Intelligence Development Studio
Exploring Business Intelligence Development Studio
Business Intelligence Development Studio - Microsoft SQL
Business Intelligence Development Studio - Microsoft SQL ...
Share this Post