I too am in the midst of similar SSRS migration (2008SSRS:2016SSRS
). Yes, the reports will need to be downloaded from one server and moved to the other. Also you will likely need to migrate other SSRS content-- shared data sources, shared data sets, report subscriptions. Below are some tools and processes that have worked well.
Tools:
ReportSync
is an open source program free to download and use. It works great for downloading reports in bulk, and it can even push a report from one server to another server.
I downloaded the source code files from Github (http://github.com/phires/reportsync), ran VS, opened the solution file (.SLN), compiled the program, found the executable file (.EXE) from the 'C:\Temp\reportsync-master\bin\Release' folder, and saved the .EXE somewhere for me to use regularly
This Export feature was marvelous for simply dumping all the RDL files to a folder for me to access and add to a VS Solution Project
RS Utility
with ssrs_migration.rss
script file is similar to ReportSync program, except it is run via command line and published by Microsoft. This utility in my experience will migrate more report content than ReportSync, but I don't think it is as simple to use and you cannot easily cherry-pick the content to move (it moves everything within the Source to Target). For more information:
As an example, the following command moved all datasources from Source to Target server...
rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://gcod049/ReportServer -v ts=http://gcop046/reportserver -v f=”/Data Sources/03-PROD” -v tf=”/Data Sources”
Visual Studio 2015 with SSDT addin
is my preferred environment for storing and deploying the files to the report files DEV SSRS server (.RDL- Report Definition , .RSD- Shared Datasets , .RDS- Shared Datasources, rptproj- Report Project).
- I have a report project file for each target folder on the server (~20 ssrs folders and vs projects). You configure the SSRS Project with the appropriate deployment information (
server url
, ssrs version
, target folder
, etc.)
Version Control
will help you be much more agile with report change requests. This will allow you to make changes to the report fiels (.RDL) and quickly restore or compare changes.
- I use
Visual Studio 2015
with ANKHSVN for Visual Studio
connected to SVN server repository
Process:
- I also analyzed the report execution history to identify reports no longer used. I decomissioned these reports the DEV SSRS server to a folder called something to the effect of:
\Decomissioned\SSRS 2008 Migration\
Also take a looks at some of my SO posts where I have documented some of my SSRS questions/ answers.
9 Answers
+---------+--------------------------------------------------------------------+-------------------+
| Votes | SO Posted Answers | Posted |
+---------+--------------------------------------------------------------------+-------------------+
| 0 | Visual Studio SSRS RDL Files creating a new file (backup) when | Sep 28 at 19:28 |
| | opened | |
+---------+--------------------------------------------------------------------+-------------------+
| 0 | is there a way to query future SSRS subscription schedules? | Sep 20 at 16:14 |
+---------+--------------------------------------------------------------------+-------------------+
| 0 | There is an error in XML document (2, 2): Visual Studio, SSRS | Aug 10 at 14:50 |
| | Project file errors (VS2015-VS2017) | |
+---------+--------------------------------------------------------------------+-------------------+
| 0 | AnkhSvn undo/revert a commit | Aug 8 at 17:04 |
+---------+--------------------------------------------------------------------+-------------------+
| 3 | SSRS file error message: The number of defined parameters is not | Jul 23 at 20:05 |
| | equal to the number of cell definitions in the parameter panel | |
+---------+--------------------------------------------------------------------+-------------------+
| 0 | How do I move subreports into their own folder? | Jul 20 at 19:55 |
+---------+--------------------------------------------------------------------+-------------------+
| 1 | SSRS Permissions | Jul 9 at 17:43 |
+---------+--------------------------------------------------------------------+-------------------+
| 1 | SSRS 2008 Report Snapshot Timestamp | Jul 2 at 19:36 |
+---------+--------------------------------------------------------------------+-------------------+
| 2 | Add ssrs report description | Jun 26 at 16:11 |
+---------+--------------------------------------------------------------------+-------------------+
Other Favorited posts
How do I copy SSRS reports to a new server if I am not the owner of the reports (ReportSync answer by nunespascal)
ssrs_migration.rss file (RS Utility script file download)
SSRS Migration Sharepoint Integrated to Standalone (RS Utility script file syntax)
how to migrate or copy SSRS datasource from one server to another without restoring the report server (RS Utility script file download)