Hi, here is what I could find for Service Manager and Orchestrator. I have performed the Orchestrator migration in the past. Note that Orchestrator 2016 is not much different from Orchestrator 2012, the steps will be the same. I hope this helps. Good luck.
SCSM: https://learn.microsoft.com/en-us/system-center/scsm/move-databases?view=sc-sm-2016&tabs=SQLServerDB
Other Links:
https://www.ozgeozkaya.com/2018/10/moving-orchestrator-database/