Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Migrate RS from 2005 to 2008

Author  Topic 

access4forums
Starting Member

3 Posts

Posted - 2010-01-11 : 18:35:33
Hi,
I have installed reporting service 2005 on a web machine and the ReportServer DB is on SQL 2005 ( different machines).
I can I just migrate from SQL 2005 to SQL 2008 without having to install reporting service 2008.

I am hoping I should be able to do the following:
1.backup reportserver and reportservertempDB from SQL 2005
2. backup config file for reporting services.
3. restore 1. On SQL 2008
4.Using Reporting services configuration manager, point to the 2008 reportserver DBs.

Any pointer will help,

Thanks,

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-01-11 : 18:40:56
No as the RS databases have changed between the two versions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -