locked
Automated Deployment RRS feed

  • Question

  • Is there any mechnism of auto deployment of reports. Any tools please help me. I know only one method thaTt is sending it through project, through target report server and Url method.

    Tuesday, April 20, 2010 2:48 AM

Answers

  • RS.exe is the utility that ships with SSRS which can be used for creating an automated deployment script for deploying reports. The RS.exe tool references a Report Server Script (.rss) file, which contains Visual Basic.Net code based on the Web Service Description Language (WSDL) API

     

    http://msdn.microsoft.com/en-us/library/ms162839.aspx


    Praxy
    • Proposed as answer by Challen Fu Friday, April 23, 2010 4:51 AM
    • Marked as answer by Challen Fu Monday, April 26, 2010 10:19 AM
    Tuesday, April 20, 2010 3:59 AM
  • This is my preferred tool for autodeployment and what more, its free :)

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

    RSS SCripter

     


    Cheers,
    Jason
    My Blog
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
    • Marked as answer by Challen Fu Monday, April 26, 2010 10:19 AM
    Tuesday, April 20, 2010 5:01 AM

All replies

  • RS.exe is the utility that ships with SSRS which can be used for creating an automated deployment script for deploying reports. The RS.exe tool references a Report Server Script (.rss) file, which contains Visual Basic.Net code based on the Web Service Description Language (WSDL) API

     

    http://msdn.microsoft.com/en-us/library/ms162839.aspx


    Praxy
    • Proposed as answer by Challen Fu Friday, April 23, 2010 4:51 AM
    • Marked as answer by Challen Fu Monday, April 26, 2010 10:19 AM
    Tuesday, April 20, 2010 3:59 AM
  • This is my preferred tool for autodeployment and what more, its free :)

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

    RSS SCripter

     


    Cheers,
    Jason
    My Blog
    P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
    • Marked as answer by Challen Fu Monday, April 26, 2010 10:19 AM
    Tuesday, April 20, 2010 5:01 AM
  • Hello Navind,

    maybe you could read http://rubenwillems.blogspot.com/

    He describes the combination with the rsscripter tool to create packages, who will then be deployed by a automated mechanism (CC) to +70 remote servers (at our client's sites)

    The combination is, in the given context, a nice  and workable solution.

    Regards,

    Vulcan900

    Tuesday, April 20, 2010 6:28 AM
  • Report services scripter file from the above link is not compatible with SQL server 2012.

    Please let me know if anyone has alternative to automate the SSRS 2012 reports deployment.


    Raj

    Monday, October 8, 2012 9:08 AM
  • Is it best practice to go for SSRS deployment using T-SQL scripts?

    Example:

    For Schedules, Reportserver.dbo.Schedule

    For Subscriptions, Reportserver.dbo.Subscriptions

    For Report Schedules, Reportserver.dbo.ReportSchedule

    Please let me know your valuable feedback.

    Note: The reason why we have used this approach is, the RSS scripter file is not compatible with SSRS 2012.


    Raj

    Tuesday, November 6, 2012 8:38 AM