Groups | Blog | Home
all groups > sql server reporting services > june 2004 >

sql server reporting services : How to move/deploy Reports from one server to another


RA
6/29/2004 5:20:10 PM
I have some reports(.rdl) files in a solution.

It is on MyServer1. And I can see using Internet Explorer; entering Location
as http://MyServer1/Reports

Is there a way I can deploy it to other Computer MyServer2 in particular
location and then run using http://MyServer2/Reports

Any suggestions?

Tudor Trufinescu (MSFT)
6/29/2004 6:56:45 PM
One way to do this is by creating a .rss script, basically a VB.NET script
that runs against the report server SOAP endpoint.
You can use rs.exe to run the script. There is more information on rs.exe up
on MSDN or books online.

If you want to do this from the designer, it is enough to change the server
name in the project properies pane.

--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Tudor Trufinescu (MSFT)
6/30/2004 9:31:03 AM
That's correct. You may also need to set the data sources for your reports,
look at SetReportDataSources, etc...

--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

RA
6/30/2004 10:54:53 AM
Thank you Tudor for reply.

I would try the first suggestion.
From the Books online I found following steps to do it.

1. Set your script variable to URL of the Source Server.
2. Use GetReportDefinition and GetProperties Methods to retrieve the report
definition and properties of the report.
3. Set the URL to point to the destination server.
4. Use CreateReport Method, passing properties returned from the
GetProperties and report definition returned by GetReportDefinition.

Am I on right track.

[quoted text, click to view]

kamel
6/30/2004 2:44:46 PM
bacup and restore ReportingService database

U¿ytkownik "RA" <rchaudhary-nospam@storis.com> napisa³ w wiadomo¶ci
news:upMps6hXEHA.3284@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button