July 7, 2015 at 10:23 pm
We are using the sql serveSqr 2008r2. We have SSRS reports. We are migrating to Sql 2014. But the database is installed in different machine. We are planning to use the logshipping for migration.
How to migrate the SSRS reports. Just backup the reportserver & encryption key is fine or do I need to consider any things?
July 8, 2015 at 2:59 am
You can do what you said in your last line, However I prefer using the migration tool. It will move the RDLs, shared data sets and sources to the new server.
July 8, 2015 at 9:36 am
What is that migration tool
July 9, 2015 at 1:45 am
ramana3327 (7/8/2015)
What is that migration tool
Google / Bing is my friend
http://www.microsoft.com/en-us/download/details.aspx?id=29560"> http://www.microsoft.com/en-us/download/details.aspx?id=29560
July 15, 2015 at 2:56 am
Thank you
July 15, 2015 at 7:12 am
Search for a tool called RSScripter.
This will script your reports out for you and deploy them to the new server
June 29, 2016 at 11:00 am
Doesn't appear any links to RSScripter are valid any more.
I'm guessing the Microsoft tool Blob_Eater linked us to is our only option?
I'm migrating SSRS from a 2008R2 instance to 2014.
June 30, 2016 at 7:07 am
plaid_draco (6/29/2016)
Doesn't appear any links to RSScripter are valid any more.I'm guessing the Microsoft tool Blob_Eater linked us to is our only option?
I'm migrating SSRS from a 2008R2 instance to 2014.
It does say :
•Source and target server must be SQL Server Reporting Services 2008 R2 or later.
I haven't tested it on 2014, but works ok with 2012.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply