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.