September 1, 2015 at 1:12 am
I am a newbie at this.Any assistance is appreciated.
I have to upgrade a 2000 reportserver(RS_OLD) to 2008 reportingserver(RSDB_NEW) and the existing
reportserver RS_OLD currently has its reporting database on a 2008 SQL server(RD_OLD).
Can I do the following ?
1.Build a New SQL Box(RSDB_NEW) with SQL 2008 Database engine and 2008 Reporting Services, install Backup compatibility tools for SQL Reports.
2.Backup and restore ReportServer DB and ReportServerTemp DB from RD_OLD to RSDB_NEW.
3.Point the restored database on RSDB_NEW to the ReportServer engine on RSDB_NEW.
4.Test some sample reports on RSDB_NEW.
5.Take down the original RS_OLD and Rename the new Server/instance RSDB_NEW to RS_OLD.
6.Run the configuration Manager on RSDB_NEW to rename all report URL’s back to RS_OLD.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply