kulmam92

# Customize / optimize as necessary.

# This could probably change to plain Windows Server Core as a base-image.
FROM microsoft/iis:10.0.14393.206

SHELL ["powershell"]
RUN Invoke-WebRequest "https://download.microsoft.com/download/9/B/B/9BB1309E-1A8F-4A47-A6C5-ECF76672A3B3/BuildTools_Full.exe" -OutFile "$env:TEMP\net.exe" -UseBasicParsing
RUN &  "$env:TEMP\net.exe" /Silent /Full

RUN Install-WindowsFeature NET-Framework-45-ASPNET ; \

kulmam92

#install SqlServer and TFS
cinst VisualStudioTeamFoundationServerExpress2013
cinst MsSqlServer2012ExpressWithReporting

#Configure SQL Reporting Services
$rsConfig = (Get-WmiObject `
  -namespace "root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v11\admin" `
  -class "MSReportServer_ConfigurationSetting")

#Configuring Reporting Server Virtual Directories

kulmam92

<?xml version="1.0"?>
<package xmlns="http://schemas.microsoft.com/packaging/2010/07/nuspec.xsd">
  <metadata>
    <id>_Dummy</id>
    <version>1.0.0</version>
    <authors>DBA</authors>
    <owners>SpeakSQL</owners>
    <licenseUrl>http://a.c</licenseUrl>
    <projectUrl>http://a.c</projectUrl>
    <requireLicenseAcceptance>false</requireLicenseAcceptance>

kulmam92

#requires -version 2.0
<#
.SYNOPSIS
Deploy SSRS project to a Reporting server.
.DESCRIPTION
The Deploy-SSRSProject script installs an SSRS project(DataSource, DataSet, Report) file to a Reporting Server using ReportService20XX management endpoint.
http://technet.microsoft.com/en-us/library/ee640743(v=sql.105).aspx
 
1. Get datasource, report from the .rptproj file
2. Get report list from the $ReportListFile file