Notifications
Clear all
Topic starter
We are considering merging 2 existing CPS 10 databases into a single database. Has anyone out there done this already?
We are working with a consultant but not sure we understand all the potential issues that may occur.
We are planning to merge both clinical and practice management information.
Can anyone provide feedback on the experiences you've had?
Thanks -Matt Johnson | IS Analyst | Fisher-Titus Medical Center | [email protected]
Posted : October 28, 2013 5:22 am
Sounds exciting. The obvious work will be in avoiding collision of primary keys. The primary keys in CPS tables are those numeric(19) values you see everywhere, and they are generated roughly to match the time they were created. You basically need to scan both databases and check to see [for each object type] if the same primary key was used in both DBs. If there is a collision, and there will likely be many, you will need to replace ALL references to that primary key in one of the databases. Unfortunately for you not all references are mapped using foreign key constraints so you'll need to consider every column in every table. This is an incredibly daunting task. I hope your consultant is good.
If you choose to develop a process like that, I encourage you to get the final process and program wrapped up in a neat package that can be used again. Let's hope that no more than one company in the community ever has to go through that. You can decide based on your morals and business needs whether to sell or open-source the package. Here's one vote for open source. Good luck.
Posted : December 11, 2013 12:17 pm
We did this for 9.5 (same thing essentially). this is going to take a LOT of time and becomes very tedious.
your destination DB needs to line up perfectly with the one being merged. so forms, clinical kits, variables for drug/test administration. We also had patients visit both sites and had to merge a large number of charts.
Posted : December 15, 2013 11:43 pm
You also want to make sure there is no SDIDs, PIDs, and other important key factors that link all OBS Terms, Documents, and Patient Information to Cross. A lot of work to validate, but if you are lucky, you wouldn't have to do this, but most like you might have to make some modifications to the keys and all supporting table records that use those keys to link.
Posted : January 15, 2014 2:17 am
