CODEWITHSUNDEEP
sqlsql-serversql-server-2005reporting-services
Miral
Miral

Reputation: 6038

Deploying Sql Server Reporting Services reports on production boxes

How to deploy Sql server reports on productions boxes? Locally it's not a problem, I just specify the url and then right click on project and say deploy which deploy on my local server.

But it's not gonna be the case for the production server

Upvotes: 7

Views: 16503

Answers (2)

João Vieira
João Vieira

Reputation: 1182

I recommend you create rs scripts that can be executed on production server. Take a look at Reporting Services Scripter. It's creates deployment scripts based on your current installation.

http://www.sqldbatips.com/showarticle.asp?ID=62

Upvotes: 9

Ian Nelson
Ian Nelson

Reputation: 58733

Either:

  1. Upload the RDL file through the web interface.
  2. Connect to Reporting Services from SQL Management Studio and upload the RDL through that interface.

Upvotes: 3

Related Questions