Install Reporting Services Scripter - SQL-FineBuild/Common GitHub Wiki

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

FineBuild RS Scripter Install

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:

Top

Manual RS Scripter Install

The following steps show what you would have to do to install RS Scripter manually. FineBuild does all of this work for you automatically.

Install RS Scripter

  1. Navigate to the Additional Components folder

    Right-click on RSScripter.zip and select Extract All

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ReportServiceExtras/ReportServicesScripter/RS Scripter Explorer.png)

  2. Extract all files to C:\Program Files\RS Scripter

    ![Extract](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ReportServiceExtras/ReportServicesScripter/RS Scripter Extract.png)

Setup Menu Item

  1. Navigate to C:\Program Files\RS Scripter

    Right-click on RSScripter.exe and select Copy

    ![Copy Shortcut](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ReportServiceExtras/ReportServicesScripter/RS Scripter Shortcut Copy.png)

  2. Navigate to the SQL Server Reporting Services menu folder on 2)

    Select Paste Shortcut

    ![Paste Shortcut](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ReportServiceExtras/ReportServicesScripter/RS Scripter Shortcut Paste.png)

  3. Right-click on the menu shortcut

    Rename it to RS Scripter

    ![Rename Shortcut](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/ReportServiceExtras/ReportServicesScripter/RS Scripter Shortcut Rename.png)

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install Taskpad View Report Top Install Linked Report Generator Next