Post reply

Question concerning SSRS automation

  • October 25, 2013 at 7:20 am

    #299656

    I'm looking for a way to automate the promotion of SSRS Reports, their associated data sources and their associated data sets from DEV to TEST to PROD.

    Does anyone know of a PowerShell or T-SQL script that I can pass that information into including the source and destination reporting environments and automate that deployment?

    My end goal is to create a webapp that the Help Desk can use to promote reports from each environment without DBA intervention.

    Also, DEV, TEST & PROD are all using SQL 2012 Enterprise SP1.

    Any help is greatly appreciated.

    Thanks.

  • October 25, 2013 at 7:34 am

    #1661623

    You cannot deploy SSRS with TSQL unfortunately.

    Powershell might be possible though, if you can access the SSRS webservice with PowerShell.

    Usually automated deployments are done using VBScript [/url]or by MSBUILD[/url].

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 25, 2013 at 8:11 am

    #1661637

    That's what I'm hoping for. I know PowerShell in 2012 added some new functionality and am just hoping someone can point me in the right direction.

    Thanks.

  • October 27, 2013 at 3:52 pm

    #1661819

    Here's a starting point:

    Deploying SSRS artefacts using Powershell (Simply)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 28, 2013 at 7:40 am

    #1661967

    How about the free reporting services scripter? http://thandor.net/article/28

    I've used it to move loads of reports between servers with great ease.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply