Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Question concerning SSRS automation Expand / Collapse
Author
Message
Posted Friday, October 25, 2013 7:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 2:11 PM
Points: 54, Visits: 349
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.
Post #1508452
Posted Friday, October 25, 2013 7:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:24 PM
Points: 13,239, Visits: 11,017
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 or by MSBUILD.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1508459
Posted Friday, October 25, 2013 8:11 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 2:11 PM
Points: 54, Visits: 349
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.
Post #1508475
Posted Sunday, October 27, 2013 3:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:24 PM
Points: 13,239, Visits: 11,017
Here's a starting point:

Deploying SSRS artefacts using Powershell (Simply)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1508713
Posted Monday, October 28, 2013 7:40 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 9:32 AM
Points: 559, Visits: 1,203
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.
Post #1508883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse