Request for Patient Data Reset Script in OpenMRS

Question

Has anyone developed or used a script to reset patient data in OpenMRS while preserving metadata? If so, could you share your solution or experience here?

Background

  • Our previous approach: install fresh OpenMRS, load current metadata, create database dump
  • Issue: This approach fails when metadata changes occur, resulting in loss of crucial data

Similar Solutions

  • Bahmni has a utility script for a similar purpose: clear_openmrs.sql
  • Not sure if anyone in the community has experience with this script

cc @dkayiwa @ibacher @achachiez @corneliouzbett @samuel34 @mogoodrich @michaelbontyes @pirupius @vasharma05 @slubwama @aojwang @ssmusoke

1 Like

Why not just build on the Bahmni script?

If there is no other existing script/approach then that’s what we can do. What do you think @michaelbontyes