In the last couple of weeks I had to plan the migration of our OpsMgr infrastructure to brand new systems, at the same time, since Cumulative Update 4 adds support for upgrading the OpsMgr database to SQL Server 2008 R2 I wanted to add such a migration as well.
While there are many source of information for such a migration I found there’s no definitive guide for this double hop: the Technet articles still reference SQL 2008 and knowledge base articles just take into account one side or another of the migration.
Proceeding with cut and paste from Technet articles and adding our own experience I managed to build a complete guide for such an upgrade, with two pluses to standard documentation (immo):
- ability to migrate custom reports and scheduled reports
- disk space and migration time reduction avoiding the backup and restore operations in favor of a copy / attach action
Since the guide is pretty long I link it in pdf format: Unofficial Guide to SQL 2008 R2 Upgrade.
The guide has been tested in our lab and then in our production environment with success. Obviously every environment is different, use it with a grain of salt at your own risk.
This posting is provided "AS IS" with no warranties, and confers no rights.