1.

Explain the command prompt utilities available in SQL Server Reporting Services (SSRS).

Answer»

Following are the command prompt utilities available in SQL Server Reporting Services (SSRS):-

RS.exe utility: The rs utility is a script host that allows you to run scripted commands. It has its source code in the rs.exe file. Run Microsoft VISUAL Basic scripts to copy data across report server databases, produce reports, create objects in a report server database, and more with this tool. It supports both Native and SharePoint deployment modes.

Powershell cmdlets: Powershell cmdlets are becoming increasingly popular among power users and IT professionals as a PREFERRED language and command-line interface. CMdlets are used to interface with the CLI; in PowerShell, the majority of them are written in C and perform functions that return a.NET OBJECT. Only SharePoint modes are supported, and it installs SSRS SERVICE and proxy servers as well as deploying and managing SSRS apps and proxies.

The following is a list of the most HELPFUL PowerShell cmdlets:

  • Get-Command
  • Get-Member
  • Get-Help
  • Get-Process

Rsconfig utility: Rsconfig utility is a script host that is used to perform scripted tasks such as publishing reports, creating items in a report server database, and setting and managing report server database connections. 'rsconfig.exe' is the command file, and it only supports native developer mode.

RsKeymgmt utility: The 'rskeymgmt.exe' command is an encryption key management tool that is used in database recovery procedures. Only the Native development mode is supported. Using the command line, you may also back up, apply, rebuild, and delete symmetric keys.



Discussion

No Comment Found