Groups | Blog | Home
all groups > sql server reporting services > march 2006 >

sql server reporting services : What is the recommended way of replicating reporting services?


kimcheebowl
3/3/2006 9:25:33 AM
We are currently running RS2000. We have a test server that I has
RS2000 on it as well. I need to replicate all the reports on our
production server to the test server.


Without uploading individual reports, what's the recommended way of
replicating all these reports?
justinsaraceno
3/3/2006 9:56:28 AM
If you have the reports in a Visual Studio project, change the deployment
target to your new test server and redeploy them.

[quoted text, click to view]
MegaGreg
3/3/2006 10:10:24 AM
If you used Visual Studio, and don't have a complicated directory
structory, you can use the deploy function to upload all the reports
and data sources. Just make a new configuration for your new server.
Branden
3/3/2006 10:30:29 AM
I have also come across an interesting utility you might want to investigate.
http://www.sqldbatips.com/showarticle.asp?ID=62


[quoted text, click to view]
kimcheebowl
3/3/2006 1:40:46 PM
Unfortunately, we do. I did find some threads regarding RS Scripter.
It seems to be working well. Although I did run into an error.
grrrrr.

Thanks
kimcheebowl
3/3/2006 2:30:06 PM
yup, i downloaded the newest version. thanks!
Bruce L-C [MVP]
3/3/2006 4:09:34 PM
Do you have the upgrade?

[quoted text, click to view]
An updated version of Reporting Services Scripter is now available (Build

2.0.0.5). This release adds a commandline version (RSScripterCmd), a new

scripting mode to generate input files for RSScripterCmd and fixes an issue

with some scripting options being ignored when scripting Linked Reports.

Please see the readme for details on scripting from the command line

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

--

HTH,

Jasper Smith (SQL Server MVP)

http://www.sqldbatips.com

[quoted text, click to view]


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services




[quoted text, click to view]

AddThis Social Bookmark Button