Install Reporting Services Scripter
| Previous Install Taskpad View Report | Manual Install | Install Linked Report Generator Next |
|---|
FineBuild can install and configure Reporting Services Scripter (RS Scripter) as part of the SQL Server install process. If you do not want to include RS Scripter in your FineBuild install, then do not download it.
RS Scripter was written by Jasper Smith, a former SQL Server MVP. It was chosen to be included in FineBuild because it enables scripting of Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another.
RS Scripter works with all SSRS components up to SQL Server 2008, but does not process Report Parts or any other components introduced from SQL Server 2008 R2 onwards. The original web site that hosted RS Scripter is no longer available and a copy captured by Web Archive is used below.
| Item | Location |
|---|---|
| RS Scripter archived home page | https://web.archive.org/web/20120830141644/http://www.sqldbatips.com/showarticle.asp?ID=62 |
| RS Scripter archived download | https://web.archive.org/web/20120830141644/http://www.sqldbatips.com/samples/code/RSScripter/RSScripter.zip |
| RS Scripter archived documentation | https://web.archive.org/web/20120220094708/http://www.sqldbatips.com/samples/code/RSScripter/readme.htm |
| RS Scripter introduction | https://siddhumehta.blogspot.com/2009/10/how-to-automate-ssrs-reports-deployment.html |
| RS Scripter report deployment | https://ranimsbi.blogspot.com/2010/12/using-rs-scripter-to-create-deployment.html |
Automated silent installation of RS Scripter is performed by Process Id 4RC and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2017 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2016 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2014 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2012 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008R2 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2008 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes | |
| SQL2005 | /SetupRSScripter: | Yes | Yes | Yes |
| /SetupSQLTools: | No | Yes | Yes |
In order to maintain compatibility with older versions of SQL FineBuild, the parameters /InstRSScripter: and /InstSQLTools: can also be used.
FineBuild also uses the following parameters to help install RS Scripter:
| Prameter | Default Value | Description |
|---|---|---|
| /RSScripterZip: | RSScripter.zip | Name of file holding RS Scripter install media |
RS Scripter will be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
RS Scripter cannot be installed by FineBuild on a Windows Core operating system because it is supplied in zip file format.
The FineBuild install for RS Scripter includes the following:
The following steps show what you would have to do to install RS Scripter manually. FineBuild does all of this work for you automatically.
-
Navigate to the Additional Components folder
Right-click on RSScripter.zip and select Extract All
-
Extract all files to C:\Program Files\RS Scripter
-
Navigate to C:\Program Files\RS Scripter
Right-click on RSScripter.exe and select Copy
-
Navigate to the SQL Server Reporting Services menu folder on 2)
Select Paste Shortcut
-
Right-click on the menu shortcut
Rename it to RS Scripter
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
| Previous Install Taskpad View Report | Top | Install Linked Report Generator Next |
|---|