Here are the steps which I followed for successful movement of the PROD SCSM 2012 SP1 environment to the DEV SCSM 2012 SP1 environment.
For getting the SCSM DW on the DEV server, followed the below steps. Installed the SCSM DEV DW with new DW databases.
Removed the existing DW registration from the SCSM DB on the DEV environment using the following cmdlets.
Un-registration of SCSM DW from CMDB : Import-Module 'C:\Program Files\Microsoft System Center\Service Manager 2012\Powershell\System.Center.Service.Manager.psd1'
Once after importing the cmdlet, I ran the following cmdlet to remove the DW registration.
$class=get-scclass -Name Microsoft.SystemCenter.ResourceAccessLayer.DwSdkResourceStore
get-scclassinstance -class $class | remove-scclassinstance
Now I registered the SCSM DW in the DEV environment and it was successful.
Santosh Killekar - Support Engineer (System Center)
Disclaimer: This posting is provided "AS IS" with no warranties and confers no rights.