Notifications
Clear all
Topic starter
Has anyone done a full migration of centricity from one sql server to another along with all of the peripheral systems such as eSm, Document Management, SMPP and analytics?
If so, how long did it take you to get everything setup and going?
Posted : October 5, 2016 7:51 am
Of course, GE wants you to pay them thousands to do it for you. We just did a sql server migration in August for the database server only. That part just took a few hours to get CPS 12.08 up and running. It should have taken half of the next business day to get all of those peripheral systems reconnected, but we ran into some snags:
1. Problem searching didn't work in the Chart module, making providers furious. To fix that we had to wait six hours for an answer, and do these steps:
Stop jboss service (which interrupts users)
Delete the folders in the SOLR folder (FS, PM, QS Folders)
Restart jboss service
2. Mik wouldn't play nice with Windows server 2012, so we had to move it somewhere else. We put it where one of our DTS sessions runs.
3. Secure messaging got weirdly sort of broken and took a couple of weeks to get fixed completely. We couldn't append documents and send them to patients. Surescripts support worked a few sessions to get it straight.
Posted : October 5, 2016 8:28 am
Is there an install guide for CPS 12?
Something we could reference for install process? For SQL, JBOSS, and so on?
Posted : October 5, 2016 8:48 am
@ErnieT, You have everything on one SQL server. That will take some time. Last time I did my move I had everything setup in a new VM and all the SQL scripts ready to go to backup and restore the DB's. It took longer to double and triple check everything than to do the move that being said it was still a full night. We also only had SQL, and ESM on the same server. DM is on another server.
Posted : October 5, 2016 9:52 am
@jsander You can usually get MIK to work on Server 2012 IF the CPS client is also installed. As soon as I did that it worked fine ok Win 2012.
Posted : October 5, 2016 9:53 am
Ernie, there is not exact time that anyone can give you as it will all depend on how much preparation you do ahead of time, size of your environment, and if data transfer is within the same subnet or is it Wide Area. When we moved from On Premise to our current Cloud Environment, I began planning three months in advance. If you can prep the environment ahead of time, especially the Database server and JBOSS, it will save you a lot of time. For example, create the new Servers and restore your backup - what this allows is to test CPS and then all you have to do is restore the backup.
The peripherals is easy for the most part except Patient Portal/Secure Messaging. When I migrated to new servers, I broke mine, so had to get GE to fix it. As for eSM and DM, those are easy and relatively quick.
Feel free to reach if or we can talk more if you need in Austin.
Posted : October 5, 2016 11:34 am
I have built new servers many times during CPS upgrades. There is nothing like that fresh Windows install feeling with a clean registry and you are going to be down anyway for the CPS upgrade. I don't have everything on the same server so my SQL server is just for the database, Jboss is on its own VM, DTS on it's own VM (with multiple other interfaces), DM on its own VM, etc. I have MS Data Center licensing in a virtual environment so there is not additional cost for the Windows licensing. I built it the way I did to make it possible to reboot something or take something offline, if necessary, without affecting too many people. Such a reboot is much faster too, due to minimal services on said VM. It makes upgrading things simpler too. Lots of the work can be prepped during business hours and cut over to the new server at night. I make sure that the new server is staged, configured and tested before the cut to make sure it will be a smooth transition. You can and should keep the old VMs around to access in case you forgot to copy a config file or something.
It is getting very easy to to do this stuff yourself. Even with a GE assisted upgrade you have to be your own project manager anyway because they won't be updating workstations, working with other vendors, or helping with custom stuff anyway.
This is mostly possible due to virtualization. If you don't have that much space on your main infrastructure you can build the new VMs on old hardware or even a workstation with a couple of 4tb drives then copy to production when the time comes.
As far as the time to do this, it is hard to say, but it is just added time to the usual upgrades. For a CPS upgrade it only takes about 10 hours longer to make new VMs, configure and update them. I do that during the day while doing other stuff anyway. It doesn't add that much time to the actual CPS upgrade.
Mike Zavolas
Tallahassee Neurological Clinic
Posted : October 6, 2016 2:02 am
Topic starter
@tnc Are you running separate sql instance for each database?
@bovie Same question to you?
Posted : October 6, 2016 2:26 am
Topic starter
If you have a log in for the GE SSO site, you can get a pdf showing the install steps. It is usually included in the Full Install download or you can get the upgrade instructions that will walk you through it.
Posted : October 6, 2016 7:20 am
