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

近期下载者

相关文件


收藏者