In this post we will see how to work with SSRS PowerShell so we can remap SSRS or SQL Sever Reporting Server Database to an existing DB, we will see also how to restore SSRS encryption key -�
You can see this video, if you would like to find more information about how to restore the old database to the new SQL server by running the command line and TFS Restore tool.
- First download the PowerShell SSRS Modules using NuGet for PowerShell (NuGet Provider), Run PowerShell as admin and type the following:
1
Install-Module -Name ReportingServicesTools
Because I didn't have NuGet for PowerShell, I got the following message
1
2
3
4
5
NuGet provider is required to continue
PowerShellGet requires NuGet provider version '2.8.5.201' or newer to interact with NuGet-based repositories. The NuGet provider must be available in 'C:\Program
Files\PackageManagement\ProviderAssemblies' or 'C:\Users\mradwan\AppData\Local\PackageManagement\ProviderAssemblies'. You can also install the NuGet provider by running
'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'. Do you want PowerShellGet to install and import the NuGet provider now?
[Y] Yes [N] No [S] Suspend [?] Help (default is "Y"):
By agree, it will install both, NuGet and SSRS PowerShell Modules, to displayed all the commands in that module, type -
1
Get-Command -Module ReportingServicesTools
This will display all the command
To know how to use the needed command, type
1
get-help set-rsdatabase
This will download the latest help and display the help, to see some examples in how to use that command, type
1
get-help set-rsdatabase -examples
Change the SSRS Database to map to the old DB, I used the new name of the machine
1
Set-RsDatabase -DatabaseServerName MyServer_Name -Name MyReportServerDB_Name -IsExistingDatabase -DatabaseCredentialType ServiceAccount -Confirm:$false
Restore SSRS Encryption Key
1
Restore-RSEncryptionKey -Password 'MyPassword' -KeyPath 'C:\Partial Autoamtion\CRMSRSReportKey.snk'
If you would like to learn more about different tools and ways for Team Foundation Server to Visual Studio Team Services migration, - have a look at the quick guide about real stories for migrating Team Foundation Server to Visual Studio Team Services. The guide describes some of the real migration scenarios and explains how to use different tools for several cases.