EPTS Merge Tool

Merge tool to combine multiple OpenMRS databases from EPTS into a single one. Built in 2 versions: Shell Script and Docker

Getting Started

This instructions will help you run both versions of the tool.

Script Version

Prerequisites

• MySQL 5.7 installed;
• Java 7 or higher installed;
• Git installed;

Instalation, configuration and execution

• Go to home directory cd;
• Clone the repository git clone https://github.com/edrisse/epts-database-merge.git;
• Run script ~/epts-database-merge/script/sql-scripts/create-elt-user.sql on local database;
• Go into script version directory cd epts-database-merge/script;
• Copy the provided pdi.zip and mysql-connector-java.jar files into epts-database-merge/script directory;
• Run setup script ./setup.sh;
• Copy the database dumps of the databases to be merged into dumps directory;
• Run the merge tool ./merge.sh from epts-database-merge/script directory;
• After excution the logs for the merge of each database can be found on epts-database-merge/script/logs directory;
• Merged database dump can be found on epts-database-merge/script/output;

Docker Version

Prerequisites

• Docker installed;
• Git installed;

Instalation, configuration and execution

• Go to home directory cd;
• Clone the repository git clone https://github.com/edrisse/epts-database-merge.git;
• Go into docker version directory cd epts-database-merge/docker;
• Run ./setup.sh;
• Copy the database dumps of the databases to be merged into dumps-to-process directory;
• Run the merge tool ./run-merge-tool.sh;
• After excution the logs for the merge of each database can be found on epts-database-merge/docker/logs directory;
• Merged database dump can be found on epts-database-merge/docker/output;