Migrating Records from one SQL EMR to OpenMRS

Hello All, Hope this question meet you all in good health, in my organisation we are migrating our existing records from our EMR that host it data’s in SQL to the adopted OpenMRS.

I was able to write the script that move data’s into the following tables in OpenMRS MySQL database patient data’s into Person; Person_name; Person_Address; Person_Attribute; patient; patient_identifier patient_program .

My issue is logging to OpenMRS to view these records they are not showing , I have tried all i could to no avail. I need any assistance that will show them in find Patient.

I really appreciate any of your help.

Thank you all

Does it help after rebuilding the search index using an equivalent of this https://demo.openmrs.org/openmrs/admin/maintenance/searchIndex.htm on your system?

Thank you Daniel, good to see you responding to my question, after your visit to Lagos - Nigeria i have not had any contact with you. I did as you asked but the records didn’t appear i still get only one record which i entered from OpenMRS see below what i have on OpenMRS

please any help will be appreciated.

Do you get any results when you search using your equivalent of this screen? https://demo.openmrs.org/openmrs/findPatient.htm

Many thanks again, i did findPatient.htm it didn’t work either i tried using both the identifier and patient_id at different times still no result, find below the result image:

still waiting for any solution

Thank you all

Search using the patient name.

I want to thank you immensely for all the support, while i upload the our current EMR data into person and patient with all the other tables, I forgot to set Voided to zero (0) after doing this and run the searchIndex.htm it start to displaying Names of patients along with it Id’s

Thank you

Hi Daniel, Hope you are doing Fine and in good health, Please Daniel, i have two issues and i will need you Technical Assistance (TA).

First, I have migrated our patient Records from MS-SQL Server based EMR to OpenMRS, but accessing patient record from Patient dashboard (Recent Visit) Takes a long time to display.

Second, after this displaying patient records in access area tabified (i.e Pharmacy order, Laboratory order, Care,Vital ), when you click on View detail this will show UI Framework Exception Error. Why is this happening.

Please help me.


Do you think you can share the tomcat log at pastebin.com?

Do you mind sharing your experience and approach to the migration? We have a task to migrate from a MS SQL based system to KenyaEMR and we are currently planning on writing a script to do that. I will appreciate your response.

Regards, Antony

Hi Antony, very sorry i am just seeing you question and i am wondering how you mean Ms-SQL to OpenMRS

Also it is easy getting me on my personal email “abrahmaolatubosun1973@gmail.com