UPDATE I have a SCOM 2007 R2 server that uses a sql 2005 server.
Machine 1: SCOM (SCOM 2007 R2 - W2K3) Machine 2: SQL2005 (SQL 2005 SP2 - W2K3) SQL Cluster: SQLCLUSTER (SQL 2008 R2 on Cluster - W2K8R2) Reporting Services is on one of the cluster machines as it's not cluster aware.
I Currently use SQL2005 for OperationsManager, OperationsManagerDW db, and Reporting services.
I need to know how to migrate All this (Including Reporting Services) to the cluster.
Reinstalling is not an option since I don't know how to do this, and don't want to lose data.
Microsoft released the SCOM 2007 R2 CU 4 that does support Migration to SQL 2008 R2.
I've found this tutorial on updating SCOM 2007 R2 to CU 4 and followed it:
This KB says: The feature for SQL Server 2008 database update support lets you upgrade a database for SCOM 2007 R2 to SQL Server 2008 R2. The tools for this feature are in the SupportTools folder of the update package. For more information about how to upgrade a database from SCOM 2007 R2, visit the following Microsoft TechNet article: http://technet.microsoft.com/en-us/library/dd789004.aspx
In the following upgrade scenarios, follow the steps that are described on the "How to update a database from SCOM 2007 R2" TechNet website: SQL Reporting Services 2005 to SQL Reporting Services 2008 Service Pack 1 (SP1) SQL Reporting Services 2008 Service Pack 1 (SP1) to SQL Reporting Services 2008 R2
So I guess I have to upgrade to SQL 2008, and then I'll be able to migrate to SQL 2008 R2, however I already have a SQL 2008 R2 Cluster and want to simply add this databases and reporting services there, if anyone have info on this I would gladly apreciate it.