Migrate a System Center Orchestrator database to a different SQL Server

SCORCH Logo

Last updated on March 30th, 2023 at 07:01 pm

Read Time:1 Minute, 54 Second

We were running through our list of servers and looking at what each one was doing in terms of Domain Controllers, Exchange servers, SQL servers, System Center servers etc when we noticed that we had quite a few servers that were using pretty small databases but had a large amount of host resource allocated to it. We also noticed that we had a large amount of 2008 R2 servers that we wanted rid of. We had a few server 2016 virtual machines available to us that already had SQL Server 2016 installed on them and plenty of room to migrate some databases on to them.

So one of the smaller databases we had on a Server 2008 R2 virtual machine was our System Center Orchestrator (SCORCH) database. We could live with this being down in working hours so we thought that we would hit this one first, allowing us to then completely discommission the old Server 2008 R2 server.

I have installed System Center products more times than I can remember and can probably do it with my eyes closed, but I had never migrated a SCORCH database before. So, like all good techies, I headed to Google hoping that someone had written a nice simple easy to follow guide. After trying a few out there, it looked like there wasn’t any simple, easy to follow guides and I had probably balls up our SCORCH database.

But I then came across a guide which I read all the way through first and seemed pretty simple, easy to follow and at this point, I was desperate so I went straight into it and gave it a go.

It worked! I was chuffed to bits, but mostly relived! The guide was spot on and every step was perfectly written and simple to follow. So here it is:

How to Migrate an Orchestrator Database

I would like to express my thanks for saving my evening on that one – strangely enough I’ve not migrated any System Center databases since! But I would be confident with using this guide for SCORCH again if I had to.

Feedback

We would love to hear your feedback on this article so come and join us on Facebook or Twitter and let us know what you think!

Click to rate this post!
[Total: 0 Average: 0]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 441 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.


Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.