RS Upgrade

  • 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