January 13, 2015 at 4:54 am
What are the steps to migrate SSRS in 2008 to SQL 2012. Do I have to move 2 ReportServer databases?
January 13, 2015 at 6:03 am
Moving the databases is indeed an option.
Migrating SQL Reporting Services to a new server by moving the Reporting Services databases[/url]
Be aware of the encryption.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2015 at 3:13 am
1. Do I have to move ReportServerTempDB too?
2. Apart from moving ReportDB's, any other way to migrate Reports?
February 23, 2015 at 1:39 am
balasach82 (2/22/2015)
1. Do I have to move ReportServerTempDB too?2. Apart from moving ReportDB's, any other way to migrate Reports?
1. In the article I linked to they restore the ReportServerTempDB as well, so I would guess yes.
2. You can extract all reports and deploy them to the new server. Do you have the reports in Visual Studio?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 23, 2015 at 8:03 pm
Restore both of the reportserver databases to the new instance. Some back I tried just the ReportServer database and got an error that I can't remember - restore both and all worked nicely.
I would do this rather than go back to the source in Visual Studio. By restoring the databases, you will preserve all of the permissions, datasources, subscriptions and any other customisations/updates made after the reports were deployed.
February 25, 2015 at 5:17 am
If you have already configured ssrs on the new instance then it is more challenging. The best thing to do is to install but don't configure ssrs on the new server. Backup and restore your reportserver and repoetservertempdb databases from previous server over to new one. Then manually configure ssrs from the ssrs configuration manager where you will attach the ssrs databases to your new ssrs instance. Once you do this and start running your reports then they will update and everything should be fine.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply