Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Centricity Migration

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

9 Posts

6 Users

0 Reactions

79 Views

RSS

ErnieT

(@erniet)

Posts: 479

Honorable Member

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

jsander

(@jsander)

Posts: 108

Estimable Member

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

chews on straws

(@jwollard)

Posts: 46

Trusted Member

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

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

@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

Marketing Committee

(@marketing_committee)

Posts: 358

Reputable Member

@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

abulsara

(@abulsara)

Posts: 150

Estimable Member

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

tnc

(@tnc)

Posts: 517

Honorable Member

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

ErnieT

(@erniet)

Posts: 479

Honorable Member

Topic starter

@tnc Are you running separate sql instance for each database?

@bovie Same question to you?

Posted : October 6, 2016 2:26 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

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

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed