Wednesday, March 28, 2012

Report deployment without VS

Hi!
I created several reports and I want to give them to several persons for the installation on

their SQL Server 2005. Is it possible to create something like an

installation package (similar to the deployment manifest in SSIS)?
Thanks for any help!

Check out the PublishSampleReports.rss script in the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples folder.

You can use it with the rs.exe tool to automatically publish an RDL definition to a server. To use it, your user will have to type a command, however.

If you *totally* want to automate deployment of reports you could do so by creating an MSI which uses a custom action: That custom action would essentially call the same commands as in the script above...It seems like a lot of work to me, though.

|||You can use Reporting Services Scripter to do this. Simply select the reports + datasource you want to distribute (and probably the folder too) and generate the scripts. You can then supply the generated scripts/rdl + batch file to them and all they have to do is change the servername and run the batchfile.|||

...and Jasper's reply reminds me that you can also now script this stuff right from SQL Managment Studio just like you could script tables, views, etc. back in 2000.

Launch SSMS, connect to your Report Server, then right-click the object you want to distribute and click Script.

No comments:

Post a Comment