Monday, July 21, 2014

Migrate SSRS reporting database from 2005 to 2012

1. take database backup from source SSRS.
2. save encryption key from source SSRS.
3. migrate database backup and encryption key file to SSRS destination server.
4. stop SSRS services at destination server.
5. Restore database with overwrite option.
5. update encryption key in destination SSRS server from SSRS configuration window.

No comments:

Post a Comment