Developing and Deploying SQL Sever Apps on Windows Integrity

5 of 39
• Visual Studio 2005 installs Business Intelligence Development Studio (BIDS) and
.NET Frame Work Software Development Kit (SDK) 2.0
by default.
•
Visual Studio 2005 and BIDS are not designed to install on IA64 servers.
5. SQL Server 2005 Samples and Sample Databases
. This is needed to execute the
examples in this paper and your own learning purpose. This is optional.
6. Microsoft SQL Server 2005 Reports Packs
: Report pack consists of a set of predefined
reports, a sample database, etc and you can use these templates to quickly author
and distribute new interactive reports. This is optional.
7. Microsoft SQL Server 2005 Feature Packs
: Feature pack is a collection of standalone
install packages that provide additional value for SQL Server 2005. This is optional.
Tools
The following tools are used for development, deployment, configuration and management of
SQL Server 2005 applications. The list is not exhaustive but it is essential for Integrity
application deployments.
SQL Server Management Studio (on both Integrity Server and Windows Client)
SQL Server Management Studio (SSMS) is an integrated environment for accessing,
configuring, managing, administering, and developing components of SQL Server. SSMS can
be used to manage applications developed from Business Intelligence Development Studio like
Integration Services, Analysis Services and Reporting Services. It also has the query editor for
the scripting capabilities of Transact-SQL, MDX, DMX, XML/A, and XML.
To launch SQL Server Management Studio, on the taskbar, click Start, point to
All Programs, Microsoft SQL Server 2005, and then click SQL Server Management
Studio. A sample SSMS screen is shown below with all the SQL instances connected to it.
Business Intelligence Development Studio (ONLY on Windows Client)
Business Intelligence Development Studio is the primary development environments for SQL
Server 2005 business intelligence solutions. The figure below shows the projects available for
the business intelligence solutions from the installed templates. Business Intelligence
Development Studio is the 32-bit development environment with Visual Studio 2005 design
interface. All the BI solutions developed from it on a 32-bit machine can be deployed on IA64
servers just like as on other 32-bit machines, including OnceClick
deployment.