October 25, 2011 at 2:49 pm
Any one has practical experience of upgraing Reporting service 2005 to 2008?
We need to do a in place upgrade of the SQL server, this server only has reporting service and database engine installed for the reportserver database and reportservertempdb.
Any things need to pay attention to?
Also any documentation about the feature comparison for reporting service 2005 vs 2008
Thanks
October 25, 2011 at 3:13 pm
If it is all on the same server you should not have too many issues. Converting your reports may be the only thing that poses an issue, but I have not run into any problems with that. Make sure you have a backup of your reports though, because when you convert them to 2008 you cannot convert them back.
Thanks,
Jared
Jared
CE - Microsoft
October 25, 2011 at 3:18 pm
Thanks, for the convert of the reports, we may later spend time working on that.
For now, I would like to know if do a in place upgrade, because the database server that hosts reportserver dbs are in the same computer, so I guess the upgrade will do both database engine and reporting service.
But I know for SQL reporting service 2005 it is IIS, 2008 don't use IIS, so when doing the upgrade for reporting service, will it shut down IIS, and aware of IIS is still there or else?
Thanks
October 25, 2011 at 3:26 pm
That I am not sure of... However, I don't remember having a problem with it when I did it. Can you set up a test server for this?
Jared
Jared
CE - Microsoft
October 27, 2011 at 11:53 am
I will certainly do from test server first.
But it would be good to know before hand, do I need to stop IIS before the upgrade, or I don't need to do so.
October 31, 2011 at 5:17 am
extract any reports, etc from the 2005 instance using Reporting services scripter tool(unless you have backups, which you do have dont you 😉 )
uninstall the sql server 2005 instance, you may uninstall IIS if you wish
perform a clean install of 2008 instance
deploy reports
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 9:13 am
Perry Whittle (10/31/2011)
extract any reports, etc from the 2005 instance using Reporting services scripter tool(unless you have backups, which you do have dont you 😉 )uninstall the sql server 2005 instance, you may uninstall IIS if you wish
perform a clean install of 2008 instance
deploy reports
So you don't recommend to upgrade in place, instead you recommend to uninstall then install 2008, then deploy reports.
If possible, I would like to upgrade in place, this way I don't need to reconfigure security, data source etc.
We do have a lot reports there.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply