
Manual Upgrade for Report Server Database
Starting in SQL Server 2005 Service Pack 2 (SP2), the Report Server service is able to auto-detect the version of the report server database and upgrade it to the schema that matches the version of the current report server instance. When an older version of the database is detected, you are prompted to upgrade it. If you proceed to upgrade it, the schema is updated to the new format and you cannot roll it back to a previous format.
Because the auto-upgrade feature has been added, there is no longer any need for you to create a database upgrade script or for having a manual upgrade option in the Reporting Services Configuration tool. In SQL Server 2008 Reporting Services (SSRS), the button to create the script and the button that performs the upgrade action are removed from the Database Setup page in the Reporting Services Configuration tool. For more information about upgrade support, see Upgrading a Report Server Database.