Openmrs Data Migration from Bahmni 0.92 to Bahmni Standard

I have developed all the custom code in the Bahmni Standard OpenMRS setup, and now I need to migrate data from Bahmni 0.92 to Bahmni Standard.

What would be the best migration approach?

  1. Export data from the Bahmni 0.92 OpenMRS database into CSV files and import it into the Bahmni Standard OpenMRS database.

  2. Take a dump of the Bahmni 0.92 OpenMRS database, restore it in the Bahmni Standard environment, and then resolve any compatibility or migration-related issues.

@angshuonline @akhilmalhotra @rahu1ramesh @sanjayap

Between the two approaches, taking a database dump, restoring it in the new test environment, and resolving compatibility issues is the would be my recommendation. @angshuonline @mohant can add more about this.

Since you are migrating from Bahmni 0.92 (CentOS-based) to Bahmni Standard (Docker-based), the migration involves updating the core OpenMRS database schema as well as moving from OpenERP 7 to Odoo 16.

It is critical to perform a dry run of this entire process in a staging, dev, or QA environment using a copy of production data before attempting the live cutover.

Please follow these official guides to execute the migration safely:

  1. Upgrading Bahmni on CentOS to Bahmni Standard or Lite on Docker
  2. Migrating Bahmni from CentOS to Docker (Training)
  3. Migrate Patient and Encounter Data
  4. Migrating Master Data from OpenERP 7 to Odoo 16

Please feel free to reach out if you encounter any roadblocks during your testing phase.

Hello all,

According to the document, I backed up all the artifacts from Bahmni 0.92 and added the backup folder in Bahmni Standard environment. After that, I copied all the custom liquibase migration from Bahmni 0.92 into the masterdata/configuration/liquibase directory in the bahmni-config. I have only added the openmrsdb_backup.sql file inside the restore-artifacts directory. However, after running the following command: ./restore_bahmni_standard.sh restore-artifacts/ I encountered the following errors. I have attached the logs for reference.

openmrs-log.txt (9.8 MB)