Developing and Deploying SQL Sever Apps on Windows Integrity

3 of 39

Abstract

Visual Studio 2005 is the latest version of Microsoft’s Integrated Development Environment (IDE)

product that now offers an even richer set of tools for SQL Server development. Visual Studio 2005

enables software development for all three processor architectures that Windows supports: x86,

x64, and IA64.

BI Development Studio (BIDS) is a subset of Visual Studio 2005 focused on the development of

Integration Service, Analysis Services, and Reporting Services projects. BI Development Studio is

bundled with the toolset that ships standard with SQL Server 2005.

While neither Visual Studio 2005 nor BI Development Studio are intended to run directly on IA64

systems, developing solutions for IA64 systems using these tools is fully supported. The IDE for

Visual Studio and BI Development Studio must be hosted on an x86 or x64 system, such as a

desktop, workstation, or a notebook. The IDE is where you do the solution design, coding, editing,

compiling, and linking. You then deploy the resulting program or package to the IA64 system

either as managed code or native IA64 code using the automated deployment tools built into the

IDE. And with the aid of Visual Studio’s remote debug facility, you can perform debugging on the

target IA64 system over the network from the IDE with full source level debugging.

You can develop managed .NET applications and deploy them directly on Integrity servers without

using Visual Studio IDE. Microsoft has announced discontinuance of support for extended stored

procedures. In future versions, .NET procedures are the recommended coding method.

When you use the ClickOnce deployment technology, .NET Framework SDK, and Visual Studio

2005 remote debugging capabilities, you can be assured of the same development experience for

IA64 applications as x86 or x64. This paper provides step-by-step instructions and examples

showing you how to develop SQL Server 2005 applications on a Windows client and then deploy,

debug, and test them on HP Integrity Servers. This document includes links to further readings and

provides section on additional resources at the end.

Stora

IDE

(VS

)

Remote Debug

Facilit

IA64 Server

SQL Server

Desktop

Network

Debu

Deploy