How to migrate a Reporting Services Database

How to migrate a Reporting Services Database)
Introduction:
This document describes how to migrate a reporting services database from one computer to another and run the database on the target computer.

For more information:
For some reason, you may want to migrate the Reporting Services Database from one computer to another. For example, you can use reporting services to create reports in the application development environment of one computer, to migrate these reports to and use them in a computer's product environment, you must migrate the Reporting Services Database, Reporting Services Windows service, and reporting services web service, if you want to migrate the reporting services database and reporting services from one computer to another, you do not need to reconfigure these reports, you also do not need to re-assemble reporting services on the target computer.

There are two solutions as needed:
1. migrate the Reporting Services Database from one computer to another, and direct the Reporting Services Database to that database. follow these steps:
1. Copy the Reporting Services Database and the Reporting Services temporary database from the source computer.
Note: The default name of the Reporting Services Database is reportserver, and the default name of the Reporting Services temporary data database is reportservertempdb.
2. Restore the database copied in step 1 to the appropriate SQL server instance of the target database.
3. Point reporting services to the database restored in step 2, and run the following report server configuration command at a command prompt:
Rsconfig-C-S server name-D reporting services database name-a SQL | Windows-u user name-P User Password
Note: For more information about the rsconfig.exe command line, run the following command at the command prompt:
Rsconfig /?

II. to migrate a Reporting Services Database, Reporting Services Windows service, and reporting services web service from one computer to another, you must first obtain the key of the source computer, you can first migrate the database from the source computer to the target computer and restore the key on the target computer. To do this, follow these steps:
1. On the source computer, use the rskeymgmt.exe command line to obtain the key and run the following command line at the command prompt:
Rskeymgmt.exe-e-f path of file name-P Strong Password
For more information about the rskeymgmt.exe command line, run the following command at the command prompt:
Rskeymgmt /?
2. on the target computer, perform the following steps:
A. Install reporting services.
B. Stop the Reporting Services Windows service.
C. Stop IIS.
3. Copy the reporting services database and reporting services temporary database of the source computer to the target database and restore it to an appropriate SQL server instance.
Note: The default name of the Reporting Services Database is reportserver, and the default name of the Reporting Services temporary data database is reportservertempdb.
4. On the target computer, perform the following steps:
A. Start the Reporting Services Windows service.
B. Start IIS.
C. Copy the third step to the reporting servicesdata database of the target computer, use rsconfig.exe to configure the Report Server instance, and run the following report server configuration command at a command prompt:
Rsconfig-C-S server name-D reporting services database name-a SQL | Windows-u user name-P User Password
Note: For more information about the rsconfig.exe command line, run the following command at the command prompt:
Rsconfig /?
D. Use the rskeymgmt.exe command line to apply the key to the target computer and run the following command at the command prompt (the following path of file name and strong password obtained in step 1 ):
Rskeymgmt-a-f path of file name-P Strong Password

Environment: Windows2003 + iis6.0 + Reporting Services Enterprise Edition