This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 ; \ |