DataWarehouse to DEV

Question

There are already uploading required information to the data warehouse on a schedule. So we could potentially be ingesting it directly from there on to DEV server. How can we proceed with this?

Answer 1

Hi @SQLLover21 ,

can you please post some more information on the challenge you are facing? What are you trying to achieve?
You can lookup some of the examples here regrading querying the SCSM Data Warehouse DB:

Service Manager Data WareHouse SQL Queries
https://itblog.no/5618

The following source will help you in better understanding the SCSM DW schema:

Service Manager Data Warehouse schema now available
https://techcommunity.microsoft.com/t5/system-center-blog/service-manager-data-warehouse-schema-now-available/ba-p/342625

What you can also do is backing up the DB and restoring it to your DEV server, like depicted here:

Move the Service Manager and data warehouse databases to different servers

and in particular:

Move data warehouse databases

The last source is one of the best link collections of links, related to the SCSM data warehouse I have ever seen, maybe you will find it helpful:

System Center Service Manager Data Warehouse and Reporting
https://social.technet.microsoft.com/wiki/contents/articles/15608.system-center-service-manager-data-warehouse-and-reporting.aspx

I hope I was able to help you out!

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Best regards,
Stoyan