Service Manager Data Warehouse Database Migration

Microsoft has documented in details how to move Service Manager Data Warehouse databases to another SQL instance. Do not attempt to move the Reporting Services database in the same way because it will fail. I will explain how to move them in another post.

The databases that can be moved between different SQL instances are:

  • DWStagingAndConfig
  • DWRepository
  • DWDataMart
  • CMDWDataMart
  • OMDWDataMart

The overall steps are listed below. You need SQL admin access and ability to edit SQL tables and registry entries.

  1. Locate user accounts and instances of SQL Server used by DW databases
  2. Stop Service Manager services on DW management server
  3. Back up the DW databases
  4. Take the DW databases offline (close all query windows)
  5. Restore the DW databases on the new computer running SQL Server
  6. Prepare the DW databases on the new database server
  7. Update DW management Server with the new database server name
  8. Update the data sources on the existing Reporting Server (Moving RS Database to a different server is not supported – same FQDN server only supported)
  9. Update the data sources for the existing Analysis Services
  10. Start Service Manager Services on the DW management server

For details:

https://learn.microsoft.com/en-us/system-center/scsm/move-databases?view=sc-sm-2022

Related Posts

Cireson Self Service Portal Database Migration

If you are planning to move the Service Manager database, you should also need to move the Cireson Service Desk Portal to the same instance. Stop the…

Service Manager Reporting Server Database Migration

In the previous post, I explained the steps of moving the Service Manager Data Warehouse databases to another SQL instance. In this post, I will share the…

In-place OS Upgrade of Service Manager Data Warehouse

In this post, I will show the steps for in-place upgrade of Service Manager Data Warehouse management server (2019) OS from Microsoft Server 2016 to 2019. The…

Installing Zebra printer driver with SCCM

In order to install Zebra printer driver to the computers with SCCM, you will first need to extract the driver content from the exe file. Deselect all…

In-place OS Upgrade of Service Manager Data Warehouse Server

In this post, I will show the steps for in-place upgrade of Service Manager Data Warehouse management server (1801) OS from Microsoft Server 2012 R2 to 2016….

In-place OS Upgrade of Service Manager

In this post, I will show the steps for in-place upgrade of Service Manager management server (1801) OS from Microsoft Server 2012 R2 to 2016. The OS…