We have a task to move reporting services 2005 instance to new servers with 2008 R2 version.
This is what I did so far:
1. Since web and database servers are different, I first installed sql server on database server.
2. Installed reporting services on web server.
3. Restored ReportServer and ReportserverTempdb to the new 2008 R2 database server.
4. Configured reporting services and selected resored reportserver and reportservertempdb on the new server.
I can access the URLs and reports now.
This is my first time touching reporting services. Our reporting services guy in the team is gone and we have a very tight deadline to deliver test, stage and prod environments in next 3 weeks.
We have over 250 reports. From the collected info, I believe that there is no custom configuration.
Our Development team has given us estimate of 2 manual months offshore and 80 hours onsite to convert all reports to 2008 R2. First of all, we don't have that kind of time and second, I am trying to find out what is left to do now and whether it is worth paying so much money to development.
I searched the forums and articles but I am not clear on when to conclude that the migration is done. Do I need to open every report in BIDs and save it in order to upgrade it? If yes, is there any script or utility availabel to do that?