The Operations Manager product team blog just posted some great information on what you need to know about upgrading and deploying System Center Operations Manager 2007 R2. Some of the big changes include:
Operations Manager R2 now supports OM database roles running on SQL 2008 with SP1. Please be sure install SP1 of SQL 2008 before beginning your R2 install or upgrade. Our Prerequisite checker detects for SQL 2008 SP1and will block until it is found. Note: We still continue to support SQL 2005 with SP1 or higher.
Operations Manager R2 also supports upgrading from SQL 2005 to SQL 2008. Only the Operations Manager Reporting role require special instructions. Detailed instructions can be found in the upgrade guide. Upgrading SQL Server 2005 to SQL Server 2008 Link
Operations Manager supports the following upgrade paths:
To continue reading see What’s new in R2 Deployment and Upgrade.
J.C. Hornbeck | Manageability Knowledge Engineer