Database Synchronization

for OpenMRS

With SymmetricDS

Mentors: Mike, JustinStudent : Nadee

Steps1. Sync person table

- 2 OpenMRS instances2. SyncSDS module

SymmetricDSSyncModuleActivator - started/stopped

3. IDatabaseWriterFilter extensionDatabaseWriterFilterAdapter - beforeWrite

4. Sync all tables (detailed on wiki page)

GSOC 2012 - OpenMRS

Demo• Full version uploaded on:

http://www.youtube.com/watch?v=vTdkSeoW7yo

• 3 min version uploaded on: http://www.youtube.com/watch?v=5b2BSqHUImQ

GSOC 2012 - OpenMRS

DemoEx:

OpenMRS Root instance : port 8044

OpenMRS Client instance : port 8055

Symmetric root : port 8080

Symmetric client : port 9090

sym -p omrsroot.properties --auto-create

sym -p omrsroot.properties --run-sql openmrs_sds_sql.sql

sym -p root.properties --port 8080 --server

sym -p client.properties --port 9090 --server

GSOC 2012 - OpenMRS

Thank You