Friday, June 15, 2012

Migrating Reporting Services To SQL Server 2008

Migration -- It is defined as moving databases from one version to other version.

1. Keep Full backup of ReportServer databases.

2. Keep all configuration files ready (reporting services configuration files)

3. Backup the reporting services encryption key

4. Attach the Report Server databases / Restore ReportServer databases in newly installed server.

5. Make necessary changes in the reportserver.config file based on the existing configuration file.

6. Configure the report server and point to the new server by specifying existing reporting server databases

No comments: