Curious if anyone has documented what order to shutdown servers/services when moving your CPS environment. An example would be to shut down services that feed into the Linklogic inbox before shutting down the DTS...things like that. Any feedback is appreciated.
Off the top of my head I would say:
Stop 3rd party apps writing to DTS or directly to Centricity database. This would include things like Patient Portal, eRx, Qvera, Visual Signature Capture (grin) and a ton of other things possibly.
Stop DTS
Kill all user sessions and disable RDP/Citrix if applicable
Stop JBoss (this also effectively stops people from logging in)
Stop SQL Server Agent
Stop SQL Server
Move SQL Server database, bring it online, and verify you can query the tables
Start SQL Agent
Start JBoss
Run a Centricity fat client and make sure you can log into Centricity and patient data is available
Start DTS
Start Qvera
Start other 3rd party applications and TEST, TEST, TEST
Give users access again (if you were able to keep them out in the first place after JBoss came back online)
You should be on the lookout for file permission issues in moves. Also firewall issues may arise. You might even have SQL user permission issues depending on how/what you moved. If you move servers where PDF attachments are, you have to update the references in the EXTREFERENCES table, MONIKER field.
Others should chime in as this is from my Medical Informatics days and it has been a couple of years. Also, we were CEMR and not CPS.
Good luck - we'll all keep you in our prayers!
Thanks for your feedback and prayers!