Developing and Deploying SQL Sever Apps on Windows Integrity

34 of 39
Develop and Deploy Applications without Visual Studio
Business Intelligence applications are developed in Business Intelligence Studio (BIDS) which
is part of the Visual Studio tool set. Without BIDS very limited actions can be performed for
the BI application arena. But most of the BI objects can be managed through SQL Server
Management Studio directly from Integrity Server.
• For Integration Services, package design and debugging needs BIDS. However SQL
server Import Export Wizard which does not needs BIDS can perform some primitive
data transfer. Also the packages can be managed by editing the package XML files for
connection, configurations, etc.
•
For Analysis Services, you can create Scripts projects to manipulate and apply
changes to objects on an instance directly from Management Studio. Analysis Services
uses a variety of languages and protocols like
MDX, DMX, ASSL and XMLA to manage its
data objects which all can be accessed from Management Studio.
• For Reporting Services, Report builder and Report Manager can run in Integrity
Server without BIDS. Also RDL can be edited to manage Reports without BIDS.
All .NET applications can be written directly on Integrity Server
with any text editor and
compiled from the command line using the .NET Frame Work Software Development Kit
(SDK). Also Microsoft CLR Debugger on Integrity Server will be a very helpful tool too. Though
it is not a commonly used practice, a simple few lines of .NET code is manageable from
Integrity.
¾ There are three Framework products, .NET Framework 1.0, .NET Framework 1.1,
and .NET Framework version 2.0, and all the three may co-exist in the same
machine. Microsoft web site Debugging with .Net Frame Work SDK
provides more
details on this topic.
¾ Go to the c:\ProgramFiles\Microsoft.NET\SDK\v2.0\Samples folder. Open
startsample.html. Click setup the Quick starts and run the ConfigSamples.exe
program. This will give you a head start on several .NET features/samples
available on 64-bit platforms.
¾ On the taskbar, click Start, point to All Programs, point to Microsoft .NET
Frame works SDK v2.0 (64bit). Several tools are available from this area.
Some of them are mentioned below:
DbgCLR.exe - Microsoft CLR Debugger for runtime bugs fix.
Fuslogvw.exe - Assembly Binding Log Viewer display details of failed assembly
Mdbg.exe and cordbg.exe - command line debuggers
Gacutil.exe - Manipulate the global assembly cache