April 14, 2015 at 7:33 am
I need to migrate Reports from a SQL Server 2008 R2 Server to SQL Server 2014 Reporting Services.
Reporting Services is installed on one Server and the Reporting Services is installed on another Server.
On the existing Server the Encryption was never backed up.
What do I do with the key?
The following article provides some good information but it does not identify what to do with the Destination URL.
It mentions to download the files but it does not specify how to identify the path and it does not state where to upload them.
Do you restore the existing Reporting Services Databases to the new Server?
Does anyone know of an article that goes into a little more detail?
Any advice would be greatly appreciated.
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/
April 14, 2015 at 8:33 am
Usually, the tool I use for this kind of tasks is a script for rs.exe.
Here's a detailed description of the script: https://msdn.microsoft.com/en-us/library/dn531017.aspx
-- Gianluca Sartori
April 14, 2015 at 8:44 am
spaghettidba (4/14/2015)
Usually, the tool I use for this kind of tasks is a script for rs.exe.Here's a detailed description of the script: https://msdn.microsoft.com/en-us/library/dn531017.aspx
Nice script but it is a little hard to follow for I do not know much about SSRS other than installing deployment and managing subscriptions.
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 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply