Migrate SSRS from 2008 R2 to SQL Server 2014

Question

Migrate SSRS from 2008 R2 to SQL Server 2014

Welsh Corgi

SSC Guru

Points: 116520
More actions
March 28, 2015 at 3:01 pm

#295498

I need to Migrate SSRS from 2008 R2 to SQL Server 2014.
What is the best method?
I understand that you can backup and restore the Reporting Services Databases and copy the configuration files.
I was also told that there is a utility that you can use to migrate but I never got the details.
What is the best and easiest method?
Edit: I am not doing an in place upgrade.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29387 More actions · Answer 1

Welsh Corgi (3/28/2015)
I need to Migrate SSRS from 2008 R2 to SQL Server 2014.
What is the best method?
I understand that you can backup and restore the Reporting Services Databases and copy the configuration files.
I was also told that there is a utility that you can use to migrate but I never got the details.
What is the best and easiest method?
Edit: I am not doing an in place upgrade.

I reckon the easiest is backup SSRS databases and the encryption key and restore them to the SQL 2014 server. Brings all reports, datasources, permissions etc with it.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Where are the encryption keys stored?

What about the configuration files?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

happycat59 One Orange Chip Points: 29387 More actions · Answer 3

Welsh Corgi (3/30/2015)
Where are the encryption keys stored?
What about the configuration files?

You need to backup the encryption key using either the RS utility or the SSRS Configuration tool.

As far as the configuration files - I would be a little more careful about this. There are changes between versions - I suggest you use the SSRS config tool to change what you can and carefully edit the config files for any other changes you need to make. Make a backup of any files you are editing first...otherwise you may end up corrupting your installation.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

happycat59 (3/30/2015)
Welsh Corgi (3/30/2015)
Where are the encryption keys stored?
What about the configuration files?
You need to backup the encryption key using either the RS utility or the SSRS Configuration tool.
As far as the configuration files - I would be a little more careful about this. There are changes between versions - I suggest you use the SSRS config tool to change what you can and carefully edit the config files for any other changes you need to make. Make a backup of any files you are editing first...otherwise you may end up corrupting your installation.

Thanks.

I was not planning on doing an in place upgrade.

I do not know who setup the server but the encryption key has not been backed up.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/