[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1248
  • Last Modified:

how to deploy sql reports to the production server ?


I have developed few sql reports, i want a installer similar kind of application installer to install /deploy sql reports to the report server.

currently i am deploying from solution file to the staging server or i use report manager to upload reports one by one.

is there any kind of option of uploading all the files together to the production server since there will be no visual studio in production environment

1 Solution
You can use rs.exe utility on your production server to execute Reporting Services scripts. In those scripts you can put some code that will deploy your reports. See examples: http://msdn2.microsoft.com/en-us/library/ms160854.aspx (there is PublishSampleReports.rss script).

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now