I command thee...
A, not uncommon request from SQL Server Reporting Services customers is the ability to use command line switches wtih Business Intelligence Development Studio (BIDS) like you would with a standardout of the box Visual Studio experience. Well, I am happy to say, we have done some work in this area for SQL Server Reporting Services 2008, and the RC0 release due very soon. I wanted to show a few samples so you can see whats coming and because its not a visual feature, your not likely to see it at the upcomming Tech Ed, for the many which will attend. Tech Ed North America 2008. Surprisingly, command line output does not draw the same crowd as cool new data visualization or richly formatted text features. Go figure.
As background, the samples I did here were with a fresh install of SQL Server 2008, so I had not installed Visual Studio 2008. Also, I should note there is lots of documentation on MSDN for using the Visual Studio command line but I found some of the samples differ in syntax. So, I based mine on what I read wih the command line help, or 'devenv /?'. A word of wisdom, when dealing with file paths which contain spaces. The double quotes are the standard, however be aware of the character difference when you are copyin/pasting between applications. Someone, could in theory, waste a lot of time trying to get command line operations to work, and swear they had the syntax proper, but there is difference between " and “
Also, I am generally lazy so to make make things easier I added the path to the folder containing DEVENV to my OS environment path, so
C:Program FilesMicrosoft Visual Studio 9.0Common7IDE
Deploy: Well, the clear winner and main desire folks are after with the command line, is the ability to deploy to their servers....
devenv "C:Documents and SettingsmyuserMy DocumentsVisual Studio 2008projectsAworksAworks.sln" /deploy myconfig
Which spits back the following, looking like what you see in Output window inside BIDs. Notice it includes the warning for the data source, and indeed in the Project Proeprties dialog in BIDs, I set 'OverwriteDataSources' to false.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Microsoft (R) Visual Studio Version 9.0.30428.1.
Copyright (C) Microsoft Corp. All rights reserved.
------ Build started: Project: Aworks, Configuration: myconfig ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Aworks, Configuration: myconfig ------
Deploying to https://theservername/reportserver
Deploying data source '/aworks/aworks_shared'.
Warning : Cannot deploy data source aworks_shared to the server because it already exists and OverwriteDataSources is not specified.
Deploying report '/aworks/aworks_salesorderdetail'.
Deploying report '/aworks/salesandterritory'.
Deploy complete -- 0 errors, 1 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Log the output: Add the /Out switch and redirect to a file (cumulative).
devenv "C:Documents and SettingsmyuserMy DocumentsVisual Studio 2008projectsAworksAworks.sln" /deploy myconfig /out c:mybuildlog.txt
Build: to check for errors, but nothing is deployed.
devenv "C:Documents and SettingsmyuserMy DocumentsVisual Studio 2008projectsAworksAworks.sln" /build
Comments
Anonymous
July 12, 2008
Here is an awesome tip courtesy to the Craig Guyer's I Command Thee blog . You probably know thatAnonymous
April 21, 2010
Please let me know prerequsite for Sharepoint Reporting Dashboard I have SQL Server 2008 (SSRS ) MOSS Server hosted How to integrate SSRS & MOSS. I want to use SSO Authntication What Prerequesites are need to install on Developer machine. i have Visual Studio 2005 . I need BI SSRS tool for Adhoc report buidling I have data in excel file to be exported to SQL 2008 table. (DTS or SSIS to use?) Please guide me who has implemented this Architecture Plan PrashanthSpark