Export (0) Print
Expand All

Scripting and PowerShell with Reporting Services

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Reporting Services supports a wide range of development and management scenarios through script, including the rs.exe command line utility, PowerShell cmdlets for SharePoint mode report servers, and leveraging the Reporting Services object model from PowerShell for both Native and SharePoint mode.

  • Administrators can write script in Microsoft Visual Basic to automate how they deploy and manage a report server installation. Administrators can also generate and run Transact-SQL scripts that create, configure, and update a report server database. Administrators can also use the record and playback script features in SQL Server Management Studio to automate routine maintenance tasks.

  • Developers can create custom applications that include script. You can run script that makes calls to the Report Server Web service. Almost any operation that you can write in managed code can also be written in script.

  • Reporting Services supports Microsoft Visual Basic .NET script as the script language that can be processed by the RS.exe utility, a script host that runs on the report server.

PowerShell related content

Reporting Services SharePoint mode includes Reporting Services cmdlets for report server administration.

  • PowerShell cmdlets for Reporting Services SharePoint Mode Includes the following examples:

    • Create a service application and proxy

    • Review and update a delivery extension

    • Get and set Properties of the Reporting Service Application Database, for example database timeout

    • List Data Extensions

PowerShell related content

PowerShell calling the core object model and for the most part valid for SharePoint and native mode, for example the migration work, subscription work, and more related samples for subscriptions work in SQL15.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft