ssrs-powershell-deploy
所属分类:SQL Server
开发工具:PowerShell
文件大小:34KB
下载次数:0
上传日期:2021-07-23 01:33:26
上 传 者:
sh-1993
说明: 用于将SQL Server Reporting Services项目(*.rptproj)部署到报表服务器的PowerShell脚本
(PowerShell scripts to deploy a SQL Server Reporting Services project (*.rptproj) to a Reporting Server)
文件列表:
.editorconfig (329, 2018-08-28)
.vs (0, 2018-08-28)
.vs\ProjectSettings.json (35, 2018-08-28)
.vs\slnx.sqlite (86016, 2018-08-28)
Example-Reports (0, 2018-08-28)
Example-Reports\Example-Reports.rptproj (4141, 2018-08-28)
Example-Reports\SharedSanity.rsd (652, 2018-08-28)
Example-Reports\SomeDatasource.rds (488, 2018-08-28)
Example-Reports\example-db.sql (315, 2018-08-28)
Example-Reports\sanity-analysis.rdl (17367, 2018-08-28)
LICENSE.txt (1069, 2018-08-28)
ssrs-powershell-deploy.sln (2365, 2018-08-28)
ssrs-powershell-deploy (0, 2018-08-28)
ssrs-powershell-deploy\SSRS (0, 2018-08-28)
ssrs-powershell-deploy\SSRS\Get-SSRSCredential.ps1 (376, 2018-08-28)
ssrs-powershell-deploy\SSRS\Get-SSRSProjectConfiguration.ps1 (1770, 2018-08-28)
ssrs-powershell-deploy\SSRS\New-SSRSDataSet.ps1 (1736, 2018-08-28)
ssrs-powershell-deploy\SSRS\New-SSRSDataSource.ps1 (1604, 2018-08-28)
ssrs-powershell-deploy\SSRS\New-SSRSFolder.ps1 (688, 2018-08-28)
ssrs-powershell-deploy\SSRS\New-SSRSReport.ps1 (2236, 2018-08-28)
ssrs-powershell-deploy\SSRS\New-SSRSWebServiceProxy.ps1 (1243, 2018-08-28)
ssrs-powershell-deploy\SSRS\New-XmlNamespaceManager.ps1 (478, 2018-08-28)
ssrs-powershell-deploy\SSRS\Normalize-SSRSFolder.ps1 (263, 2018-08-28)
ssrs-powershell-deploy\SSRS\Publish-SSRSProject.ps1 (6770, 2018-08-28)
ssrs-powershell-deploy\SSRS\Publish-SSRSSolution.ps1 (1495, 2018-08-28)
ssrs-powershell-deploy\SSRS\SSRS.psd1 (447, 2018-08-28)
ssrs-powershell-deploy\SSRS\SSRS.psm1 (826, 2018-08-28)
ssrs-powershell-deploy\Usage (0, 2018-08-28)
ssrs-powershell-deploy\Usage\Usage-FromCredentialFiles.ps1 (962, 2018-08-28)
ssrs-powershell-deploy\Usage\Usage-PlainText.ps1 (356, 2018-08-28)
ssrs-powershell-deploy\ssrs-powershell-deploy.pssproj (2712, 2018-08-28)
# SSRS Powershell Deploy
* https://github.com/timabell/ssrs-powershell-deploy
PowerShell module to publish SQL Server Reporting Services project(s)
(`.rptproj`) to a Reporting Server
## Chat
[![Join the chat at https://gitter.im/ssrs-powershell-deploy/Lobby](https://badges.gitter.im/Join%20Chat.svg)](https://gitter.im/ssrs-powershell-deploy/Lobby?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)
## Wiki
There's a [project wiki on
github](https://github.com/timabell/ssrs-powershell-deploy/wiki), go ahead and
expand it
## This fork
This repository was forked from:
* https://gist.github.com/Jonesie/9005796
* which was forked from https://gist.github.com/ChrisMissal/59795***
* which was forked from https://gist.github.com/jstangroome/3043878
I've turned it into a proper github repo to allow discussion, pull requests
etc.
## Installation
### PowerShell Gallery
Install the [SSRS module](https://www.powershellgallery.com/packages/SSRS/)
from [PowerShell Gallery](https://www.powershellgallery.com/):
Make sure you have PowerShell Gallery installed (instructions on their
homepage). It's already available in Windows 10.
In an elevated powershell console run:
Install-Module -Name SSRS
Say `y` to installing from untrusted. Then close the elevated console and you
will now have the `Publish-SSRSProject`/`Solution` commands available in all
your powershell sessions.
If you can't use the gallery for some reason then you can do a manual install
from a download:
### Manual install
1. Download the .zip from
https://github.com/timabell/ssrs-powershell-deploy/releases/latest
2. Right-click the zip file in windows explorer, click "properties", and then
click "Unblock".
3. Create folder `Documents\WindowsPowerShell\Modules\`
4. Open up the zip file, copy the SSRS folder, paste it into
`Documents\WindowsPowerShell\Modules\`. (Or somewhere on your
`$env:PSModulePath`)
## Usage
Publish-SSRSProject.ps1 -path YourReportsProject.rptproj -configuration Release -verbose
You can either specifiy a build configuration to read from the project file, or
you can specify all the information required to publish in the rest of the
parameters.
Publish-SSRSProject [-Path]
[[-Configuration]
] [[-ServerUrl] ] [[-Folder] ]
[[-DataSourceFolder] ] [[-DataSetFolder] ]
[[-OutputPath] ] [[-OverwriteDataSources] ]
[[-OverwriteDatasets] ] [[-Credential] ]
[]
## Example reports
To open the Example-Reports project in Visual Studio you'll need [Sql Server
Data Tools (SSDT)](https://msdn.microsoft.com/en-us/library/mt204009.aspx)
## General SSRS gotchas
Disappearing dataset panel -
http://stackoverflow.com/questions/7960824/i-lost-datasets-pane-in-visual-studio/28883272#28883272
VS report projects cache both datasets and data. Remove all the `.data` files and the
`bin/` folder(s) to be sure your changes will work when published.
http://stackoverflow.com/questions/3424928/in-ssrs-is-there-a-way-to-disable-the-rdl-data-file-creation
More SSRS love http://timwise.blogspot.co.uk/2015/08/100-reasons-i-hate-ssrs.html <3 <3
## Development
Developed with [PowerShell Tools for Visual Studio 2015](https://visualstudiogallery.msdn.microsoft.com/c9eb3ba8-0c59-4944-9a62-6eee37294597)
To test the module locally directly from the source tree you can import by specifiying the path to the psd1 file.
PS C:\repo\ReportDefinitions> Import-Module C:\repo\tim\ssrs-powershell-deploy\ssrs-powershell-deploy\SSRS\SSRS.psd1
PS C:\repo\ReportDefinitions> Publish-SSRSProject
See the exported commands with
PS C:\repo\ReportDefinitions> Get-Command -Module SSRS
CommandType Name Version Source
----------- ---- ------- ------
Function Publish-SSRSProject 1.2.0 SSRS
Function Publish-SSRSSolution 1.2.0 SSRS
Unload again with
PS C:\repo\ReportDefinitions> Remove-Module SSRS
近期下载者:
相关文件:
收藏者: